Viewing 15 posts - 16,276 through 16,290 (of 19,560 total)
MMOD
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 18, 2010 at 9:06 am
Paul White (3/18/2010)
I'm going for a short break to prevent pork-chop Armageddon.
I heard the tent is open.
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 18, 2010 at 9:04 am
Grant Fritchey (3/18/2010)
Alvin Ramard (3/18/2010)
You wanna different language? Ok, mesa know one. 🙂Down that path lies a world of pain.
I thought we liked pain
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 18, 2010 at 8:58 am
sudhakara (3/18/2010)
Thanks your reply and sharing your ideas. It will be very helpful if you people can share the prerequisites and post check list for applying the service packs.
Checklists will...
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 18, 2010 at 8:57 am
Roy Ernest (3/18/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 18, 2010 at 8:55 am
george sibbald (3/18/2010)
ensure no connections to the databases and backup systemdbs before you start, including resource database
Good recommendation
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 18, 2010 at 8:55 am
Nice article. 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 18, 2010 at 1:50 am
SSIS could be just fine for that.
I would house SSIS at the central site. You could build it such that it rolls the data up from each site, if...
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 18, 2010 at 1:36 am
Don't forget swallow and pigeon - ese
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 17, 2010 at 11:43 pm
Jeff Moden (3/17/2010)
Heh... and sometimes you have to PUSH! 😛
That's an understatement.:hehe:
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 17, 2010 at 11:40 pm
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
March 17, 2010 at 11:31 pm
Jeff Moden (3/17/2010)
I've found the same thing even on some of the MVP...
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 17, 2010 at 11:30 pm
Check out my response to the same question over on ask.sqlservercentral.com
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 17, 2010 at 11:23 pm
You could try this other methods too
select charindex(Right('HOW LONG IS THIS DATA?',1),'HOW LONG IS THIS DATA?')+1-charindex(left('HOW LONG IS THIS DATA?',1),'HOW LONG IS THIS DATA?')
select charindex(Right('HOW LONG IS THIS DATA?',1),'HOW LONG...
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 17, 2010 at 11:17 pm
If you follow all these steps, you should be fine as far as data loss goes.
In other words, you will have your bases covered and should be protected...
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 17, 2010 at 11:17 pm
Viewing 15 posts - 16,276 through 16,290 (of 19,560 total)