Viewing 15 posts - 16,156 through 16,170 (of 19,560 total)
Uncommitted
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 19, 2010 at 11:53 pm
Now that I am through the thread of discussion, here are my 2 bits.
I buy my training books or use the free materials I can find. I haven't had...
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 19, 2010 at 6:04 pm
GilaMonster (3/19/2010)
Steve Jones - Editor (3/19/2010)
Henrico Bekker (3/18/2010)
When are you coming to South Africa to host a SQL Saturday? 😉
South Africa?!?!? Isn't that 3 light days of travel from CO?...
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 19, 2010 at 5:54 pm
Jeff Moden (3/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
March 19, 2010 at 5:50 pm
Grant Fritchey (3/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
March 19, 2010 at 5:46 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 19, 2010 at 5:41 pm
Lynn Pettis (3/19/2010)
Now, when it is about 120, imagine being out on a turf field during a soccer toutnament. I haven't been there, but I have heard stories 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
March 19, 2010 at 5:27 pm
jlizzi (3/19/2010)
When a user goes into the database and opens a table to edit/add values, can...
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 19, 2010 at 4:46 pm
If you don't have any free space in the file, then you will need to seek out alternative methods. Shrinkfile should help you shrink the database - if there...
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 19, 2010 at 4:43 pm
psturn 72558 (3/19/2010)
I am able to do a DBCC CheckDB with Physical_Only.
Do you get an error message when trying to perform the
DBCC Checkdb WITH NO_INFOMSGS
command that Gail requested?
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 19, 2010 at 4:37 pm
I would like to see the actual execution plans from both servers and see if they differ at 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 19, 2010 at 4:34 pm
Otherwise, you could use the GUI and open the role in the desired database to view it's properties. Then select "securables."
This should display permissions for specific objects for 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 19, 2010 at 4:28 pm
I just uploaded a script to my blog that can help you with this.
Check it out at http://jasonbrimhall.info/?p=391
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 19, 2010 at 4:27 pm
GilaMonster (3/19/2010)
GSquared (3/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
March 19, 2010 at 4:21 pm
Please refer to this document for info on how to add or remove a node from clustering.
http://msdn.microsoft.com/en-us/library/ms191545(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 19, 2010 at 3:55 pm
Viewing 15 posts - 16,156 through 16,170 (of 19,560 total)