Viewing 15 posts - 2,476 through 2,490 (of 19,560 total)
We wouldn't expect you to put code on your server without knowing what it does. But you want a specific ability to email results of the run of checkdb....
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, 2014 at 2:13 pm
Keith Tate (7/30/2014)
Do you have a backup for the entire MSDB? If so, you can simply restore that over the new MSDB database.
That would be the easiest solution.
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, 2014 at 1:53 pm
matt6749 (7/30/2014)
My hosting company limits my combined db + log size...
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, 2014 at 1:52 pm
You can download a script here that will provide a pretty decent security audit report for you.
http://jasonbrimhall.info/2010/03/19/security-audit/
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, 2014 at 1:49 pm
This script works pretty well.
http://spaghettidba.com/2013/02/27/dba_runcheckdb-v2012/
Gianluca coded it to send results via email as well.
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, 2014 at 1:46 pm
djj (7/30/2014)
whereisSQL? (7/30/2014)
Ed Wagner (7/30/2014)
TomThomson (7/30/2014)
SQLRNNR (7/30/2014)
Ed Wagner (7/30/2014)
Stuart Davies (7/30/2014)
SQLRNNR (7/29/2014)
aardvarkDigger
Hunting (for antiques)
Pecheur
é or ê?
Tomato
ketchup
hot dog
breakfast
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, 2014 at 1:28 pm
Evil Kraig F (7/30/2014)
If you're there at that moment, and the threads are active, yes, they're easier to determine. Wait a few days and you wouldn't know the difference...
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, 2014 at 1:17 pm
TomThomson (7/30/2014)
SQLRNNR (7/30/2014)
Ed Wagner (7/30/2014)
Stuart Davies (7/30/2014)
SQLRNNR (7/29/2014)
aardvarkDigger
Hunting (for antiques)
Pecheur
é or ê?
C'est a vous a decider.
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, 2014 at 12:36 pm
Lynn Pettis (7/30/2014)
SQL Guy 1 (7/30/2014)
For instance, when you hear or read ASP what comes to your mind?
Active Service Pages
Application Service Provider
Also googled:
Appalachia Service Project
Association of Software...
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, 2014 at 12:31 pm
I have heard EMC say that about defrag and I have shown them the difference.
You may have a file queue issue.
Sum the data retrieval and data render time and subtract...
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, 2014 at 12:13 pm
If your data retrieval and rendering haven't changed, I would suspect the network or destination server to be at fault. How is the space and fragmentation on the file...
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, 2014 at 11:30 am
Trying to set like that will not work.
e.g. Set @ClientID in (...)
Where is the source of this data?
If it is coming from a database, you can use a select instead...
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, 2014 at 10:51 am
You cannot convert from tinyint to uniqueidentifier.
You will need to rewrite your code to accept the correct data types or change the data type in the table.
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, 2014 at 10:26 am
Is this thread of any help?
http://www.sqlservercentral.com/Forums/Topic1279635-266-1.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, 2014 at 9:40 am
Grant Fritchey (7/30/2014)
Early in this discussion the people who posted some sophomoric comments
Let's just call a spade a spade. Yes my comment was less than mature, but I...
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, 2014 at 9:22 am
Viewing 15 posts - 2,476 through 2,490 (of 19,560 total)