Litespeed is very good at performing this kind of compression - I've found at level 1 it's fast enough and compresses enough. We have a very full...
This NOLOCK double counting effect is the same under Read Uncommitted since they are the same lock type. The double counting can happen if say a...
I would also recommend using either service broker or MSMQ but if you don't have the authority to install either of those then this table based...
In terms of index optimisation, SQL Server 2005 DOES do some kind of automatic index optimisation.<br /><br />My current understanding of this is...
Far and away the BEST book i have ever read for this kind of stuff is T-SQL Querying by Itzik Ben-Gan. It's a must read for this kind of stuff....
Hi - been on holiday for last week. You could try creating a covering non-clustered index on all the columns you reference from #temp here. That...
re: clustered column - if you update a clustered column, sql server has to reorganise the order of the data on disk - not as simple as just updating...
When you look at the job history, ensure to open up the tree in the history view and then click on the last step to run - that should show you a...
Oh - you want the SIMPLE solution!? Who'd have thought. ;D Open up your Job properties, go to the STEP that does the business, open up properties...
Use ROLLUP or CUBE - check with Books Online to see exact format - I believe if you just use your 3rd query and add WITH ROLLUP you'll get what you...
Have you tried using BCP? You could test pretty quickly. bcp [_TK_852] in filename.txt -t * -r ~ Add flight search to your own site for free...
Use a CASE statement. case when day(calldatetime) between 1 and 7 then 1 when day(calldatetime) between 8 and 14 then 2 when day(calldatetime)...
We've had this in the past with dodgy network connections. You're running it at nighttime - 4am - and guess what - nighttime is when anyone that...
When you say KILL do you mean kill or timeout? Try the same query using the (nolock) table hint e.g. select * from tableX (nolock) and see how if...
We do same thing here - where it *really* matters we send changes to log tables and where previous changes don't matter we have CreateDate and...
On the permanent table (the one being updated) where is your clustered index? Are you updating any of the columns that the clustered index is...
Z - what type of disks are you using on this box? If you get a *few* of these errors it's normal - normally when the disks are thrashing heavily due...
If you're sure you have data in the new column it sounds like you made a mistake when you altered the transformation. My recommendation would be to...
Because the license for Workgroup edition is £500 and developer edition we already have a license for. And we don't need a license for this box cos...
Hi - does anyone know of any way (startup parameters maybe?) that I can downgrade SQL 2005 developer edition to SQL 2005 Workgroup edition? This is...
Separate names with a comma.
