|
|
-
|
|
The problems discussed in this post are far from new however they are problems still discussed frequently on various forums and problems which, for some reason or another, are still difficult to debug. Please Note: The content of this post applies to developing and deploying in a 64-bit envi......
|
|
-
|
|
Problem Calling a SQL Server Integration Services (SSIS) package from s stored procedure should be an easy task however Microsoft has provided no direct method to do so. A quick search on Google found this CodePlex example which uses the xp_cmdshell extended stored procedure to execute dtexec via......
|
|
-
|
|
After a small slip-up on the SQL Server Forums, I thought it best to remind myself (and others) of the importance of using Sargable predicates in WHERE clauses.
Definition: In relational databases, a condition (or predicate) in a query is said to be sargable if the DBMS engine can take advantage of......
|
|
-
|
|
Ever been in the situation where you’re so fixated on debugging an error that you fail to see the solution which has been staring you in the face the whole time? Me too. The other day I was trying to import data from an Excel spreadsheet into a SQL Server table using OPENROWSET (something I’ve done......
|
|
-
|
|
Introduction This is the fourth post in a series of five on Using TVP’s and XML to Transport Relational Data. In this post we’ll take a look at how Table-Valued Parameters (TVP’s) can be used to send multiple rows of data to a Transact-SQL statement or a routine, such as a stored procedure. We’l......
|
|
-
|
|
UPDATE: Thanks to l.torres (Comment #1) for information regarding An update is available to add support for testing the Product Update feature in SQL Server "Denali" CTP3 UPDATE: Hindsight is a wonderful thing. If I had remembered that you can’t upgrade ANY current edition of SQL Server t......
|
|
-
|
|
Introduction BPAY is Australia’s most widely used bill payment service which enables bill payers to transfer funds electronically from their bank accounts to billers. It is offered as a payment channel by over 170 financial institutions through their phone and Internet banking services. Sinc......
|
|
-
|
|
There’s been an update to the SQL Server 2008 R2 Developers Training Kit (May 2011). This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It contains a ric......
|
|
-
|
|
While researching content on OPENXML vs. XQuery vs. Table-Valued Parameters, I stumbled across the SQL Server Forums; a place I used to spend quite a lot of time. I also visited a number of blogs created by friends and fellow SQL Server enthusiasts. At the time I was quite happy to lap-up the copiou......
|
|
-
|
|
After installing SQL Server 2012 Service Pack 1 you will discover that SQL Server Database Projects can no longer be opened (or created) using SQL Server Data Tools (SSDT). The error presented when trying to open existing projects is: Unable to o...
|
|