Programming SQL

Using Multiple Pivot Keys
I know the limitation of PIVOT (SQL2005) ... just curious as to any tricks out there available using multiple pivot keys. SELECT * FROM TEMP_LABRESULTS pat_id labid collection_date value 1233 1 2009-01-04 7 1233 2 2009-01-04 123 1233 3 2009-01-04 88 1234 2 2009-01-6 127 ... 2 Nov 2009 21:18

What is the easiest way to empty all tables of my database?
I have small database of a little more than 2 dozens of tables. For some test, I need to empty all tables. Because of the crisscross references that exist amongst the tables, I am having a hard time empty my tables. I know I can empty them one by one by starting from the very bottom of the reference tree and ... 2 Nov 2009 21:18

Transaction and resources
Hi there, I have an app that needs to upload flat files into my DB and each file will range from a few hundred KB to a maximum of 16 MB. Normally it will be at the low end of this range however. Ideally I'd like to process each upload in a single transaction so that on any failure, none of the data will make ... 2 Nov 2009 17:58

SQL server 2000 displaying 100% cpu
hi all, I am facing one problem regarding sql server 2000. Client has reported that due to some queries cpu utilization on dataase server reches 100. We executed same queries on local environment, but not getting this problem. And client is saying that this is not happening always. sometime it is happening the... 31 Oct 2009 12:11

SQL 2005 - SQL Native Client doesn't work, MDAC does
When trying to connect to a SQL Server 2005 instance using "SQL Native Client", I get this message: [Microsoft][SQL Native Client]Unable to complete login process due to delay in opening server connection If I use the "SQL Server" driver instead, it works fine. Anyone have an idea what's wrong? Or should ... 4 Nov 2009 13:07

exec master.dbo.xp_ versus exec master..xp_
Is there any difference in executing a stored procedure this way: exec master.dbo.xp_cmdshell versus this way? exec master..xp_cmdshell They both seem to work, but are there implications I need to know about? Thanks. ... 23 Oct 2009 14:28

SSIS Package Comparison Utility (Freeware)
Hi All, We've just released a free, simple, package comparison utility for SSIS file-system based packages. SSISdiff, which requires that you have a comparison utility (such as Beyond Compare) installed, is available from here: http://www.sqlsoft.co.uk/ Best Wishes, Will Alber (SQLsoft). ... 22 Oct 2009 18:38

bin packing
For those interested, I have written a short series of articles on solving the bin packing problem. See http://www.xs4all.nl/~gertjans/sql/binpacking/intro.html -- Gert-Jan SQL Server MVP ... 10 Nov 2009 14:07

freetext problem
hi, Freetext not working properly. For example: I am writing select * from table1 where productname like '%meals for%' this query give me 5 rows but below query didn't give me any row. select * from table1 where FREETEXT (table1 .productname, meals for) why? It's working for other product name . thanks ... 21 Oct 2009 12:40

Sql Record number
I have a rather large database that I am datamining. I am doing numerous SQL sorts to determine which methodolgy works best. I would like to determine the new "record position" of a particular record in the group. Currently I am doing it programtically by itering through the records till I find the particular re... 20 Oct 2009 17:54