It's the law of home ownership, Steve... all 10 minutes jobs take at least 6 hours to complete. 😀

For both online and offline index REBUILDs (and assuming the index is over 128 extents (or 1024 pages), which is only 8MB), a brand new index will be created and...

But just ripping into the site isn't going to help anything change; we all know that constructive feedback is far better received. We've all experienced users that only...

Dear Members I have more than 50 servers with sql server installed each of them runs a backup job every day at night Exists any backup tool I can...

I'll leave this here, as we're not going to agree.

...

I hope you all still find the site and community worth supporting and continue to do so, but if not,...

Visually appealing is a personal preference. The people on this thread seem (to me and a few others) to be complaining as though the formatting is something that's right...

I believe that the UPDATE() function can help you a lot here.  For example, if the UPDATE() function is NOT true, you can shortcut the trigger with an early exit. ...

You can do this easily with string functions, but it’s still a stinking kludge caused by bad design. Most of the work in SQL is done in the DDL,...

Because of a rather insidious change that MS made for the new LOB datatypes compared to the old ones in 2005, most people's usage of LOBs causes huge problems and...

Hi there I have the following code which has to extract an number from a AccountNumber variable declare @AccountNumber varchar(20) = '8063#0018375' select SUBSTRING(@AccountNumber,CHARINDEX('#',@AccountNumber)+1,Len(@AccountNumber) - CHARINDEX('#',@AccountNumber)) select Len(SUBSTRING(@AccountNumber,CHARINDEX('#',@AccountNumber)+1,Len(@AccountNumber) -...

Ummmm.... is that where the decisions to not include critical functionality or "not good enough but we have a schedule to meet" decisions are cast in...

What a day, one could not make it up! My best friend taken to a hospital (second time in two days) after collapsing going flat on the ground,...

Hi All The table structure is as below. Whilst i get that a clustered index is the data, the thing I'm struggling to get my head round is why...

Also, you can implement compression (page or row) and get indexes smaller + less I/O and wiser RAM usage. Thanks to Kalen Delaney for the ported version of standard...

Ummmm.... is that where the decisions to not include critical functionality or "not good enough but we have a schedule to meet" decisions are cast in stone?...