Viewing 15 posts - 6,976 through 6,990 (of 59,070 total)
The U.S. Congress decided (wisely for once) that they wanted people to want to stay home without worrying about the bills. So they authorized an extra $600.00 per...
May 31, 2020 at 2:10 am
Labor Day probably makes sense. Easier to put this out there and then change later, than keep extending it.
No update from RG, but quite a few people...
May 31, 2020 at 2:05 am
Steve, great article. Thanks for taking the time to write it up, work out the nice simple demo's and post it all. Well done!
May 30, 2020 at 7:06 pm
Aha! Great article, and I can immediately see a use case for having unique numbers even across different tables, where both tables get the number generated by the same...
May 30, 2020 at 7:05 pm
Labor Day probably makes sense. Easier to put this out there and then change later, than keep extending it.
No update from RG, but quite a few people are thinking...
May 30, 2020 at 6:03 pm
This is based on your language setting.
SELECT top 10
*
FROM sys.syslanguages
There is a datefirst column here. If you change the language, you change this.
Apart from...
May 30, 2020 at 5:29 am
Rather than using DBCC SHOWCONTIG, use sys.dm_db_index_physical_stats. The row header information is included as a part of the Min, Avg, and Max row sizes.
I'd still like to know why someone...
May 29, 2020 at 8:17 pm
Since you're new, let me explain what Phil means by directing you to the first link in my signature line below. It helps others help you both a lot better...
May 29, 2020 at 5:56 pm
My objective is to find out the space occupied by each record in a table ...
To what end? What will such information be used for? I ask because the...
May 29, 2020 at 3:07 pm
The method that Phil posted is known as a "CROSSTAB" and was the way we did pivots long before the PIVOT operator became available. CROSSTABs are also generally faster than...
May 28, 2020 at 5:57 pm
Sounds like a plan... especially the part about validation before deletion. Thanks for the feedback.
May 28, 2020 at 5:53 pm
I'd say that DW in the Cloud is on the rise and is probably a safe bet.
That, notwithstanding, ask yourself what your passion is (not to mention the finances of...
May 28, 2020 at 5:47 pm
I've been living with similarly named databases that have different suffixes based on the environment for a very long time. I say "living"... what I really mean is "enforcing". We...
May 28, 2020 at 5:38 pm
What does the print statement yield?
May 27, 2020 at 2:56 pm
Today I have a peformance issue where setting legacy cardinality estimator ON helps.
From 100s to 1 sec. Really interesting.
Heh... that's not just "help"... that's a freakin' miracle and we...
May 27, 2020 at 1:45 pm
Viewing 15 posts - 6,976 through 6,990 (of 59,070 total)