Viewing 15 posts - 1,471 through 1,485 (of 4,820 total)
April 20, 2018 at 11:04 am
SQL-DBA-01 - Friday, April 20, 2018 10:42 AMCompare the results of the same trace taken on two different servers
Okay, cool. Easiest way...
April 20, 2018 at 10:51 am
April 20, 2018 at 10:29 am
All I did was change the where clause alias from:
WHERE
April 20, 2018 at 10:23 am
April 20, 2018 at 10:13 am
April 20, 2018 at 10:01 am
First order of business is to understand what kind of business process you want to have surrounding that kind of issue. Last one in wins can be painful, as you've...
April 20, 2018 at 8:53 am
April 20, 2018 at 6:45 am
Just to add some specific content to this thread, here's some things SQL 2000 can NOT use:
1.) ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD, LAG, or any aggregate where you add...
April 20, 2018 at 6:30 am
As long as we're at it, we might as well correct what appears to be a slight typo, and perhaps simplify some of the code:CREATE PROCEDURE dbo.getDashboard (
...
April 20, 2018 at 6:14 am
I'm noticing that when I copy results from a query result set by...
April 20, 2018 at 6:01 am
I was curious if there was a similar more efficient way to do a pivot...
April 19, 2018 at 1:35 pm
I have the SQL Service on Automatic restart on a machine and the agent is...
April 19, 2018 at 1:26 pm
Viewing 15 posts - 1,471 through 1,485 (of 4,820 total)