Grr.. I did a big reply and just lost it.Yes SQL Server organises the rows inside the data pages in physical order, and with no BOL info to the contrary can assume that the data pages are not in physical order. In that case it would not matter if the clustered index was ASC or […]
2004-06-09
No Backups or Maintenance was running. I was looking at active processes and nothing strange things were happenging at that time. The query (store proc) is called by aspx page and it's been running our site for at least 1/2 year without too much trouble except the fact is that the proc is heavy. And interesting […]
2004-06-09
Thanks for reply.I think I have narrowed down the problem to be something to do with the multiprocessor setup. I had a look at the execution plan for the queries and store procedures used in the application on the server machine. None of them were using any kind of parallelism. As such, only the single […]
2004-06-03
When you attempt to restore your database SQL Server will perform a safety check to eliminate the possibility of overwriting your database unintentionally and fail the operation if the database already exits. Because of this safety check you have two alternatives to restore you database:1- Let the restore operation of SQL Server re-create your database […]
2004-05-31
2004-05-30
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Krishna Sonti
2004-05-27
3 reads
I have written a script that is using OPENROWSET to connect to a server with a dynamic supplied username and password combination. If login fails I want my script to continue and try the next pair supplied. i.e when recieving Server: Msg 18456, Level 14, State 1, Line 1 Login failed for user 'user'. I […]
2004-05-27
1 reads
You also need to look closely how you're using your CASE statement.its useage/mentality is not exactly the same as VB or other languages. CASE (state) WHEN 'KS' THEN 'thisIsKS' WHEN 'MD' THEN 'thisIsMD' ELSE address END as resultOfMyCaseStatement Notice your checking the VALUE of a field.And then your WHEN are based on the value of that field.And […]
2004-05-26
p.s. this is is not a limitation of Cold Fusion. SQL doesn't accept a text field as large as my xml packets in a stored procedure call. I really don't think it would matter how I instantiate the database call to execute the procedure. (asp, .net, cold fusion, php, vbscript, etc, etc, etc.) thanks,
2004-05-26
Hmm, that is an interesting idea, let me see if the caller would be willing to send me xml instead of ',' delimited string.Thanks everyone for your ideas, I really appreciate the help/ideas.Craig
2004-05-22
1 reads
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers