egonconsulting.be

sqlarea.blogspot.com

SQL Server Area: april 2008

http://sqlarea.blogspot.com/2008_04_01_archive.html

Vrijdag 25 april 2008. Linked Server failure for IBM OLE DB Providers on SQLServer2005 X64 Cluster. I've Created Linked servers to IBM AS400 machines using the IBMDA400 and IBMSQL400 OleDb providers. If I failover, or take off-line and bring back on-line the SQL Resource Group, I get this Error:. Msg 7340, Level 16, State 4, Line 1. Cannot create a column accessor for OLE DB provider "IBMDA400" for linked server "ATCOAIRC". Or, if you don't want to do this manually - Duhhh. Exec sp enum oledb providers.

sqlarea.blogspot.com

SQL Server Area: augustus 2009

http://sqlarea.blogspot.com/2009_08_01_archive.html

Dinsdag 11 augustus 2009. SQL Traces mixing SQLServer2005 - 2008. Today was expiriencing some problem opening a Trace File:. Unable to locate trace definition file Microsoft SQL Server TraceDefinition 10.0.0.xml for open trace file. It took me more than 10 min to figure out that the server I was profiling (Using SQLServer 2005 profiler) was a SQLServer 2008. :-p. Or if you don't have the 2008 tools installed yet on your locale machine, you can use:. Links naar dit bericht. Vrijdag 7 augustus 2009. Error ...

sqlarea.blogspot.com

SQL Server Area: september 2013

http://sqlarea.blogspot.com/2013_09_01_archive.html

Maandag 9 september 2013. SQLServer Page restore (SQLServer 2005 and later). Page Restore (SQLServer 2005 and later):. A page restore is intended for repairing isolated damaged pages. Restoring and recovering a few individual pages might be faster than a file restore, reducing the amount of data that is offline during a restore operation. However, if you have to restore more than a few pages in a file, it is generally more efficient to restore the whole file. Can be restored. Page restore cannot. I work ...

sqlarea.blogspot.com

SQL Server Area: juli 2009

http://sqlarea.blogspot.com/2009_07_01_archive.html

Dinsdag 28 juli 2009. SQLServer Locking and deadlocks. In SQLServer environments with a lot of concurrency, locks, blocks and deadlocks are a very common issue. To avoid negative performance impact, here are some best practices and monitoring tools to use:. 1) Use of WITH (NOLOCK). Where applicable, use WITH (NOLOCK). In the FROM-clause and in JOIN. It avoids locks on the database while performing read-operations. FROM dbo.MyTableX AS x WITH (NOLOCK). INNER JOIN dbo.MyTableY As y WITH (NOLOCK). To avoid ...

sqlarea.blogspot.com

SQL Server Area: maart 2008

http://sqlarea.blogspot.com/2008_03_01_archive.html

Vrijdag 28 maart 2008. Login "error States" in SQL Log. 2 and 5 Invalid userid. 6 Attempt to use a Windows login name with SQL Authentication. 7 Login disabled and password mismatch. 11 and 12 Valid login but server access failure. 13 SQL Server service paused. 18 Change password required. Links naar dit bericht. Donderdag 27 maart 2008. SQL Server Management Studio takes a long time to load, how to improve the load performance of this tool? Check for publisher's certificate revocation. We will debug our...

sqlarea.blogspot.com

SQL Server Area: mei 2015

http://sqlarea.blogspot.com/2015_05_01_archive.html

Vrijdag 8 mei 2015. SSIS 2012 / 2014 SSIS Catalog Package Protection level. The last 2 days I’ve spend too much time struggling with the protection level of my SSIS Catalog deployed packages. So I investigated why I was having all those problems, and I will give you an overview of how to solve it. The Deployment of our packages is done by a PowerShell script to reduce the manual work. The Protection Level of the project and the packages was set “. MainSSISPackage.dtsx" /DECRYPT P@ssWord. This is where al...

sqlarea.blogspot.com

SQL Server Area: Getting all (calendar)days within a period

http://sqlarea.blogspot.com/2015/05/getting-all-calendardays-within-period.html

Vrijdag 8 mei 2015. Getting all (calendar)days within a period. Getting all (calendar)days within a period. Sometimes you need a list with all days within a specific period, for example to outer join with other tables to have a complete calendar overview. Here is a simple way to get those days. Create the Table-Valued Function:. Use the Option “ MAXRECURSION 0. 8221;, otherwise you will exceed the limit of maximum 100 recursions (Default Value). The “ OPTION. 8221; in the “ INSERT INTO. Zoeken in deze bl...

sqlarea.blogspot.com

SQL Server Area: mei 2008

http://sqlarea.blogspot.com/2008_05_01_archive.html

Vrijdag 16 mei 2008. SSIS debugging on 64. When I debug my SSIS package (which imports an Excel-sheet into SQLServer) on a 64-bit server, I get this errors:. Excel Source [9] Error: SSIS Error Code DTS E CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Dinsdag 6 mei 2008.