Viewing 15 posts - 2,596 through 2,610 (of 19,560 total)
Ed Wagner (7/18/2014)
SQLRNNR (7/18/2014)
Ed Wagner (7/18/2014)
SQLRNNR (7/18/2014)
mangaCarta
Don't you mean Catra?
I was referring to the Magna Carta, supposedly the document on which the US Constitution was based. The founding fathers...
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 18, 2014 at 11:41 am
If your publication database was already in simple, then the restored database should be in simple as well (upon completion of the restore).
You can change the subscription database to simple...
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 18, 2014 at 11:31 am
Sean Lange (7/18/2014)
SQLRNNR (7/18/2014)
Lynn Pettis (7/18/2014)
Why do I feel that WC is heading down a deep dark hole??Did you see somebody push him in the hole?
I have plausible deniability, 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 18, 2014 at 10:57 am
Lynn Pettis (7/18/2014)
Why do I feel that WC is heading down a deep dark hole??
Did you see somebody push him in the hole?
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 18, 2014 at 10:45 am
For me, the hardest thing seems to be high performing xml queries.
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 18, 2014 at 10:35 am
In addition to the advice given, I might go so far as to declare an emergency "hotfix" during the middle of the day for an hour or two.
Block traffic to...
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 18, 2014 at 10:00 am
Ed Wagner (7/18/2014)
SQLRNNR (7/18/2014)
mangaCarta
Don't you mean Catra?
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 18, 2014 at 9:50 am
manga
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 18, 2014 at 9:31 am
Ed Wagner (7/18/2014)
sing4you (7/18/2014)
Ed Wagner (7/18/2014)
Stuart Davies (7/18/2014)
Sean Lange (7/18/2014)
Ed Wagner (7/18/2014)
SQLRNNR (7/18/2014)
Ed Wagner (7/18/2014)
sing4you (7/18/2014)
Ed Wagner (7/18/2014)
fho 21275 (7/18/2014)
BWFC (7/18/2014)
Mulepirate
Scimitar
saber
Sword
swash
Buckle
plank
constant
Variable
transformer
bot
dino
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 18, 2014 at 9:22 am
Nadrek (7/18/2014)
anthony.green (7/15/2014)
You will need to ensure that your connection strings have the application name parameter set in them to do it
And note that copy/paste coding leads to Application D...
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 18, 2014 at 8:44 am
Try this one instead
$servers = get-content "C:\PS\list_server.txt"
$collection = $()
foreach ($server in $servers)
{
$status = @{ "ServerName" = $server; "TimeStamp" = (Get-Date -f s) }
...
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 18, 2014 at 8:40 am
I haven't had any issues installing enterprise edition from MSDN. When I downloaded and installed the enterprise version (according to MSDN), it did in fact install enterprise edition.
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 18, 2014 at 8:36 am
EL Jerry (7/18/2014)
10K (posts)
And the winner was.....
sing4you
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 18, 2014 at 8:32 am
Straight up question. It is nice to have questions about important topics such as recovery. Too many people will forget to perform that very essential first step.
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 18, 2014 at 8:11 am
jcrawf02 (7/18/2014)
**Edit - duplicate post, must be drunk...
You don't play bass do you?
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 18, 2014 at 8:08 am
Viewing 15 posts - 2,596 through 2,610 (of 19,560 total)