Viewing 15 posts - 6,706 through 6,720 (of 19,560 total)
It is a very normal setup to use AD accounts when a domain is available. Could you expound on the errors you got?
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, 2012 at 4:13 pm
Either a significant amount of data was deleted or the backup was changed to use compression.
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, 2012 at 4:10 pm
Steve Jones - SSC Editor (3/19/2012)
SQLRNNR (3/19/2012)
Steve Jones - SSC Editor (3/19/2012)
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, 2012 at 10:47 am
Nadrek (3/18/2012)
My answer to tabs vs. spaces, case convention, and pre vs post commas is always to let a computer do tedious, menial, purely rules based work - use a...
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, 2012 at 10:45 am
GilaMonster (3/19/2012)
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, 2012 at 9:23 am
obligation
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, 2012 at 9:19 am
Steve Jones - SSC Editor (3/19/2012)
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, 2012 at 9:19 am
green
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, 2012 at 12:54 pm
SQL Kiwi (2/7/2010)
Jeff Moden (2/6/2010)
For those that believe in the myth of portability, see if you can write a portable trigger. 😉
:laugh: Perfect :laugh:
My own view on the whole ISNULL...
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 16, 2012 at 1:59 pm
Lynn Pettis (3/16/2012)
SQLRNNR (3/16/2012)
crookj (3/16/2012)
Lynn Pettis (3/16/2012)
anthony.green (3/16/2012)
SQLRNNR (3/16/2012)
Lynn Pettis (3/16/2012)
anthony.green (3/16/2012)
now your just being cruel :crying:Yes, yes I was. But I love Chocolate Mousse!
truffle
truffle shuffle
Bacon
Miss Piggy?
Fozzy
Animal!
Beaker
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 16, 2012 at 1:40 pm
tempdb is automatically recreated.
Model, you can restore from backup. Alternatively you can copy the mdf and ldf into the appropriate directory
Resource, you need to make sure you have those...
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 16, 2012 at 1:01 pm
Yes you can. But you should have a backup of that database available so you can bring it back online. Sounds like you are in the middle of...
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 16, 2012 at 12:43 pm
crookj (3/16/2012)
Lynn Pettis (3/16/2012)
anthony.green (3/16/2012)
SQLRNNR (3/16/2012)
Lynn Pettis (3/16/2012)
anthony.green (3/16/2012)
now your just being cruel :crying:Yes, yes I was. But I love Chocolate Mousse!
truffle
truffle shuffle
Bacon
Miss Piggy?
Fozzy
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 16, 2012 at 12:38 pm
Create different subscriptions for each email address.
http://technet.microsoft.com/en-us/sqlserver/Video/dd420576
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 16, 2012 at 12:37 pm
Don't forget the hidden resource database.
I am curious why you are asking?
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 16, 2012 at 12:31 pm
Viewing 15 posts - 6,706 through 6,720 (of 19,560 total)