Viewing 15 posts - 46 through 60 (of 152 total)
Depending on the specifics of the implementation, you may find that the easiest way to improve performance is to get off RAID5.
Partitioning would allow you to split your table across...
March 7, 2012 at 2:48 pm
T-SQL is pretty slow at parsing / shredding XML, so you will probably find that it is better to use an exe for that. You could even make it part...
March 7, 2012 at 2:34 pm
You may want to consider using a DATENAME() instead of the cumbersome CASE statement. That would also allow some language variation dependant on the default language.
February 23, 2012 at 11:45 pm
I don't believe you can just issue a "move" command to relocate the table.
However you can create a table in the new database and do a direct copy.
January 19, 2012 at 4:52 pm
From one of the videos on Azure I've been watching there does seem to be a way to re-create a database in Azure at a point in time. I can't...
January 19, 2012 at 4:38 pm
The fact that it places a schema lock on the tempdb for the duration of the query is my issue. If the query is fast enough, this may not be...
January 2, 2012 at 10:20 pm
I was surprised and disappointed to see that the inability to use SELECT... INTO was a disadvantage.
Anything which takes that option away from developers is a good thing IMHO!
I have...
January 2, 2012 at 4:19 pm
The problem is the RETURN immediately after the RAISERROR.
The 1st answer from @sturner of increasing the severity should work as this will force execution of the CATCH.
As an...
November 21, 2011 at 12:23 am
I found Erland Sommarskogs series of articles on dynamic SQL to be both informantive and helpful on this topic.
He has some great worked examples alongside the pro's and con's of...
October 31, 2011 at 8:50 pm
Because I enjoy a challenge, here's some suggested code that may help! This will return 1 line for each Comments record with the sum of the hits counter between dates.
CREATE...
October 31, 2011 at 8:46 pm
I suspect that one of your records in the User_Master table has the created_by set to the same value as the user_id.
This sample works fine for me, but uncommenting the...
October 31, 2011 at 8:23 pm
1. Kinda - Cadets for 2 years and they did cover most of the basic training.
2. Absolutely. But it shouldn't cover any particular flavour of database, including SQL.
I know that's...
July 6, 2011 at 1:04 am
scottm30 (7/5/2011)
The moment they are dropped, users will believe the system is running slower. Furthermore any application problems will be initially blamed on the missing indexes.
So don't tell...
July 6, 2011 at 12:40 am
Viewing 15 posts - 46 through 60 (of 152 total)