Viewing 15 posts - 2,191 through 2,205 (of 19,560 total)
Here is a script that covers various scenarios. I can't remember where I got it, but the author name is still attached.
/*************************************************************************
Author ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 12:50 pm
You can try this article that shows how to do that.
http://jasonbrimhall.info/?s=duplicate+cte
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 12:12 pm
Here's another script. This one provides a few different angles for helping analyze potential missing indexes. Use it in conjunction with one of the other scripts to try...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 11:38 am
halifaxdal (8/18/2014)
SQLRNNR (8/18/2014)
halifaxdal (8/18/2014)
And why would you want to handcuff yourself like that?
I like the word "handcuff", that's not by me, it's by the platform itself, I am building a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 10:45 am
kaplan71 (8/18/2014)
The Differential backup of Friday night completed successfully. It was only...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 10:09 am
halifaxdal (8/18/2014)
And why would you want to handcuff yourself like that?
I like the word "handcuff", that's not by me, it's by the platform itself, I am building a dashboard using...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 10:05 am
kaplan71 (8/18/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 9:49 am
Jpotucek (8/18/2014)
Thank you very much!
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 9:37 am
halifaxdal (8/18/2014)
SQLRNNR (8/18/2014)
halifaxdal (8/18/2014)
unfortunately CTE is not allowed in this particular staging table creation, and even if it is allowed, 10 million records would be a lengthy dump.:crazy:
So use a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 9:33 am
It's possible they are related.
Big transaction, running on slow disk, and getting deadlocked.
The IO errors could also be due to the wait for the transaction log to grow.
Hard...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 9:19 am
halifaxdal (8/18/2014)
unfortunately CTE is not allowed in this particular staging table creation, and even if it is allowed, 10 million records would be a lengthy dump.:crazy:
So use a temp table.
Using...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 9:15 am
No. A udf in that case clause would not be better. You are grouping by something that needs to be "calculated."
Instead, why not dump that information into a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 8:42 am
bologna
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 8:39 am
sgmunson (8/18/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 8:38 am
Jpotucek (8/18/2014)
Running SQL Server 2000 SP4 and I started getting these errors in my log several days ago.
The log file for database 'tempdb' is full. Back up the transaction log...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 18, 2014 at 8:33 am
Viewing 15 posts - 2,191 through 2,205 (of 19,560 total)