Viewing 15 posts - 916 through 930 (of 1,464 total)
Lynn Pettis - Tuesday, January 23, 2018 5:54 PMSPAM alert. It just started to explode.
2 valid posts in 8 pages. The rest...
January 23, 2018 at 9:07 pm
January 23, 2018 at 8:07 am
January 22, 2018 at 2:03 am
January 21, 2018 at 9:26 pm
Mathew McGiffen's blog post Avoid “Constants” in T-SQL shows how the use of a local variable results in a scan, and excessive estimations.
January 17, 2018 at 10:46 pm
Why use the prod server?
Rather do a side-by-side install on the test server, and then export/import the data from one DB to the other.
January 16, 2018 at 10:34 am
January 16, 2018 at 4:08 am
I missed the ADDED snapshots
This should take care of Added, Removed, and Changed snapshotsWITH cteLead AS (
SELECT [ID], [SnapshotDate], [ProjectName], [ProjectValue]
...
January 10, 2018 at 12:43 am
Using LEAD will allow you to check the value of the next occurrence
WITH cteLead AS (
SELECT [ID], [SnapshotDate], [ProjectName], [ProjectValue]
, [NextVal]...
January 9, 2018 at 10:54 pm
ZZartin - Tuesday, January 9, 2018 3:01 PMPrey
Hunt
January 9, 2018 at 9:14 pm
Thank you Drew.
I will start testing and changing my list of RegEx expressions that I use.
January 2, 2018 at 12:14 pm
Take a look at the PIVOT operator
January 2, 2018 at 4:09 am
Viewing 15 posts - 916 through 930 (of 1,464 total)