Thanks for clarifying, Roji. I was familiar with modulo, but hadn't seen it for an order by. I realize that the original question was about IDs,...
I hadn't seen the ORDER BY %26 syntax before. I don't see it in Books Online. Does anyone have a source for that? I ran a quick test on one of my...
Something about ramkumar's post makes me nervous. If you use: INSERT INTO ArchiveDB..TableName SELECT * FROM YourDB..TableName WHERE DateColumnName...
Couldn't you just add the Identity attribute to the existing column in Enterprise Manager and set the Identity seed to the maximum value in the table...
There's not much info in the original question. Are the new stored procedures slower than you would expect in Query Analyzer? Do you call the...
Hi everyone, I looked in BOL and didn't find any theory on this. I have a parent / child relationship in my database between my two biggest tables...
Thanks for the reply. I think we are proving the statements about the ORDER BY being unreliable. I made a more simplified example to get rid of the...
Here is a small shell of a script I just used for partitioning my transaction history. I'm using yearly partitions, but you can adapt it to your...
Wow, thank you for the quick response! I have thought about the points you raised. The SQL 2005 compatibility will not be an issue. I am...
Hi gang, great article! I am trying to apply the technique described here, but I want to update TWO columns. I want to do a beginning and ending...
Separate names with a comma.
