Viewing 15 posts - 11,836 through 11,850 (of 19,560 total)
editing
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
October 21, 2010 at 2:54 pm
Stefan Krzywicki (10/21/2010)
CirquedeSQLeil (10/21/2010)
GilaMonster (10/21/2010)
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
Database backup methods:
Q: Explain how to rename a table.
Q: Explain how to determine 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
October 21, 2010 at 2:23 pm
GilaMonster (10/21/2010)
http://www.careerride.com/sql-server-what-is-index-segmentation.aspx
Some gems...
Q:What are the advantages of using Stored Procedures?
Database backup methods:
Q: Explain how to rename a table.
Q: Explain how to determine if a table has...
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
October 21, 2010 at 2:00 pm
Ray K (10/20/2010)
Brandie Tarvin (10/20/2010)
CirquedeSQLeil (10/20/2010)
Ray K (10/20/2010)
WordCode of the day . . .select cup from coffeewhere caffeine = 'high'
You won't get any that way, try this:
select coffee
Into #Mug
from...
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
October 20, 2010 at 9:38 am
Stefan Krzywicki (10/20/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
October 20, 2010 at 9:38 am
Ray K (10/20/2010)
WordCode of the day . . .select cup from coffeewhere caffeine = 'high'
You won't get any that way, try this:
select coffee
Into #Mug
from Pot
where caffeine = 'high'
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
October 20, 2010 at 8:03 am
ALZDBA (10/20/2010)
CirquedeSQLeil (10/19/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
October 20, 2010 at 7:57 am
Jack Corbett (10/19/2010)
CirquedeSQLeil (10/19/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
October 19, 2010 at 9:16 pm
jcrawf02 (10/19/2010)
CirquedeSQLeil (10/19/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
October 19, 2010 at 9:15 pm
I just had my rear windshield shot out as I was pulling into my driveway. Called the police to report it. They won't come out and investigate unless...
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
October 19, 2010 at 7:08 pm
Thanks - I needed something like this.
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
October 19, 2010 at 5:02 pm
good question. 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
October 19, 2010 at 4:58 pm
Another factor to consider is how frequently is the database accessed (is it a high volume transactional database)?
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
October 19, 2010 at 3:38 pm
The recommendation is "It Depends."
What do you consider a larger database?
What is your disk configuration?
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
October 19, 2010 at 3:37 pm
jcrawf02 (10/19/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
October 19, 2010 at 3:25 pm
Viewing 15 posts - 11,836 through 11,850 (of 19,560 total)