Viewing 15 posts - 16,426 through 16,440 (of 19,560 total)
Roy Ernest (3/15/2010)
people born on 29th of February never gets old... 🙂 They are always young..
They age at 1/4th the rate of the rest of us. Certainly is not...
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 15, 2010 at 2:45 pm
You're welcome.
Otherwise, I'm drawing a blank on any other method than what you described.
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 15, 2010 at 2:38 pm
Have you considered exploring powershell and SMO to do this from the SQL Server perspective?
http://msdn.microsoft.com/en-us/library/cc281947.aspx
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 15, 2010 at 2:26 pm
This should be a good starting place. There are examples throughout the sublinks in the link provided.
http://msdn.microsoft.com/en-us/library/ms180606(SQL.90).aspx
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 15, 2010 at 1:31 pm
Lynn Pettis (3/15/2010)
[font="Comic Sans MS"]Party Time is just around the corner! Just one more post is needed![/font]
You will soon qualify for that SSC Mug with pork chops in 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 15, 2010 at 1:11 pm
Lynn Pettis (3/15/2010)
USE [SandBox]
GO
/****** Object: Table [dbo].[b]JBMTest[/b] Script Date: 03/15/2010 12:49:16 ******/
Looks like a familiar setup 😉
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 15, 2010 at 1:10 pm
David Nash-367764 (3/15/2010)
Probably a misconception due to the fact that a Primary Key DOES add a unique index by nature.
That probably is true.
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 15, 2010 at 12:52 pm
eoleweb (3/11/2010)
Is it possible to implement Kerberos for SQL Server Integration Services 2008 ?
Microsoft article seems to say NO "http://msdn.microsoft.com/en-us/library/aa337083.aspx".
Can you confirm this information please ? Is there a workaround...
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 15, 2010 at 12:51 pm
Luke L (3/15/2010)
So what was I reading in another thread about Alvin and his Puns?It's all so clear now.
Keeps things lite?
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 15, 2010 at 12:44 pm
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn only needs 4 more posts for 10,000 posts (not overall pts).CountDown on?
Got the tent ready for the party? D'you sweep out all...
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 15, 2010 at 12:44 pm
Molly Cary (3/15/2010)
Great! thanks. I am seeing that it's happening around 2-3 am.
Do you by chance have an index rebuild job scheduled at that time?
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 15, 2010 at 12:40 pm
Alvin Ramard (3/15/2010)
CirquedeSQLeil (3/15/2010)
Lynn only needs 4 more posts for 10,000 posts (not overall pts).CountDown on?
Got the tent ready for the party? D'you sweep out all the hippo droppings?
Nah,...
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 15, 2010 at 12:37 pm
Alvin Ramard (3/15/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
March 15, 2010 at 12:33 pm
Lynn only needs 4 more posts for 10,000 posts (not overall pts).
CountDown on?
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 15, 2010 at 12:32 pm
I'm fine with going back to Friday evening.
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 15, 2010 at 12:31 pm
Viewing 15 posts - 16,426 through 16,440 (of 19,560 total)