Viewing 15 posts - 13,786 through 13,800 (of 19,560 total)
Gianluca Sartori (5/26/2010)
Steve Jones - Editor (5/26/2010)
no, there have been some doozy's this week. Though our PhD friend doesn't help the impression.Who? You mean this individual?
Just because b stands for...
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
May 26, 2010 at 11:06 am
I know some people that would use it (sound as evidence to efficiency) to their advantage.
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
May 26, 2010 at 11:00 am
Phil,
Thanks for the table defs and sample data. I am looking into it. In the meantime - has the revised query that was already provided been of use?
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
May 26, 2010 at 9:06 am
Nice find Steve.
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
May 26, 2010 at 9:02 am
Good one!
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
May 26, 2010 at 8:59 am
crookj (5/26/2010)
CirquedeSQLeil (5/26/2010)
malignantHope (Hoping it is just a word of the day and nothing more serious.)
Joe
just a word - following regnant
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
May 26, 2010 at 8:59 am
malignant
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
May 26, 2010 at 8:25 am
Nice concept. Thanks for sharing.
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
May 25, 2010 at 6:37 pm
You are welcome.
I think I would change the alert on that app in regards to the number of pages being an alert.
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
May 25, 2010 at 12:20 pm
Great question
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
May 25, 2010 at 10:36 am
Chris Morris-439714 (5/25/2010)
CirquedeSQLeil (5/25/2010)
Steve Jones - Editor (5/25/2010)
Chris Morris-439714 (5/25/2010)
LOLOAQICI82QB4IPOK, I'm lost again
It's an addiction. He's losing sight of reality 😉
You're a bit behind, Jase.
LOLO = 'ello, ello...
K -...
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
May 25, 2010 at 10:28 am
nik27184 (5/25/2010)
my question is i have to run this store proc from ssis for sql...
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
May 25, 2010 at 10:26 am
P Jones (5/25/2010)
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
May 25, 2010 at 10:09 am
Yes - you can run that against a 2000 db so long as you are using supported commands for SQL 2000.
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
May 25, 2010 at 10:07 am
Not a single utility.
In SSIS, you would issue a backup command via a sql script. This will backup the database to the desired location.
Once you have backed it up,...
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
May 25, 2010 at 10:02 am
Viewing 15 posts - 13,786 through 13,800 (of 19,560 total)