Viewing 15 posts - 4,381 through 4,395 (of 19,560 total)
sehgalnamit (7/31/2013)
My goal is to assign these activites to my level 1 team...
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
July 31, 2013 at 12:31 am
some of the best material you can use for training for the exams is not in a book per se. You would be amazed at how much more prepared...
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
July 31, 2013 at 12:29 am
GPO (7/30/2013)
A comprehensive discussion of the various options tried in the past can be found here:http://www.sqlservercentral.com/Forums/Topic860953-61-1.aspx
:-D: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
July 30, 2013 at 11:34 pm
Please provide the actual execution plan with this query so we can offer better advice.
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
July 30, 2013 at 10:52 pm
select *
from tempdb.sys.objects
that will list all of the objects in tempdb.
If you have restarted sql server since creating those tables then those tables are gone now.
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
July 30, 2013 at 10:46 pm
shohelr2003 (7/30/2013)
SQLRNNR (7/30/2013)
If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.NO WAY TO GET BACK?
You would...
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
July 30, 2013 at 10:29 pm
Here is an article that can help you find those growths
http://www.sqlservercentral.com/articles/Log+growth/69476/
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
July 30, 2013 at 10:02 pm
Thanks Steve
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
July 30, 2013 at 10:00 pm
If you restored a backup over the database without having performed a backup to save that important data, you have lost the data.
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
July 30, 2013 at 9:59 pm
This might be of use for you.
http://technet.microsoft.com/en-us/library/ms345359(v=sql.100).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
July 30, 2013 at 9:15 pm
do you currently have copies of your system databases in multiple locations?
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
July 30, 2013 at 9:13 pm
Grant Fritchey (7/30/2013)
SQLRNNR (7/30/2013)
Koen Verbeeck (7/30/2013)
SQLRNNR (7/29/2013)
L' Eomot Inversé (7/29/2013)
WayneS (7/29/2013)
FWIW: I prefer the older images over...
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
July 30, 2013 at 4:04 pm
Erland Sommarskog (7/30/2013)
DesmoShane (7/30/2013)
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
July 30, 2013 at 4:02 pm
Ventilate
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
July 30, 2013 at 2:47 pm
L' Eomot Inversé (7/30/2013)
SQLRNNR (7/29/2013)
Jeff Moden (7/29/2013)
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
July 30, 2013 at 2:46 pm
Viewing 15 posts - 4,381 through 4,395 (of 19,560 total)