Viewing 15 posts - 16,111 through 16,125 (of 19,560 total)
Lynn Pettis (3/22/2010)
CirquedeSQLeil (3/22/2010)
Going on 15 for me. Feels like about 5 - until I try to remember details of those early years. It's hard to remember facts...
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
March 22, 2010 at 12:19 pm
Alvin Ramard (3/22/2010)
I'm going to see if I can prepare myself for: 70-433 Microsoft 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
March 22, 2010 at 12:17 pm
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
Scenario: Backup prod and restore to a "reporting server." Usage on the reporting server...
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
March 22, 2010 at 12:14 pm
Luke L (3/22/2010)
Gianluca Sartori (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
A consulting company here installed a SQL clustered Server with two nodes...
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
March 22, 2010 at 12:08 pm
Alvin Ramard (3/22/2010)
Lynn Pettis (3/22/2010)
GSquared (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
My main subjects of conversation so far today have been politics...
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
March 22, 2010 at 12:07 pm
Gianluca Sartori (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
A consulting company here installed a SQL clustered Server with two nodes and they...
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
March 22, 2010 at 12:06 pm
Gianluca Sartori (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
A consulting company here installed a SQL clustered Server with two nodes and they...
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
March 22, 2010 at 12:05 pm
Nice article.
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
March 22, 2010 at 12:03 pm
Your monitoring job would run a script to check the job tables in the msdb database.
(sysjobhistory check the run_status column)
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
March 22, 2010 at 11:28 am
Try the following:
with increment as (
SELECT A.AB_Id, A.Priority, A.Analysis_Code
,row_number() over (order by a.ab_id) as Test_Sequence
FROM dbo.LSR_Prepare A
LEFT OUTER JOIN dbo.LSR_Pass B
ON A.AB_Id = B.AB_Id
AND A.Priority = B.Priority...
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
March 22, 2010 at 11:26 am
Yes you could do that. One method is to create another job that fires off every so often. The job will check the status of each of the...
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
March 22, 2010 at 11:14 am
Thanks
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
March 22, 2010 at 11:12 am
Nice Question. I had to think about it for a minute.
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
March 22, 2010 at 11:09 am
I think those are fair checks.
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
March 22, 2010 at 11:08 am
dpelan (3/22/2010)
I got it to work. Thanks to all for the advice.
One last quick question.
What did you do to resolve it?
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
March 22, 2010 at 10:20 am
Viewing 15 posts - 16,111 through 16,125 (of 19,560 total)