Viewing 15 posts - 1,831 through 1,845 (of 19,560 total)
jts2013 (11/14/2014)
Drat - burnt by the badly worded question, which didn't mention express edition 🙂Better luck next time!
+1
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
November 14, 2014 at 9:01 am
Grant Fritchey (11/14/2014)
Dana Medley (11/14/2014)
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
November 14, 2014 at 8:59 am
I'd be extremely cautious about removing indexes. Rare processes that use the index is one issue. Another issue is the use of index hints.
Despite showing the index was...
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
November 13, 2014 at 3:49 pm
zahid.nawaz (11/13/2014)
@SQLRNNR
: why maintenance plan is brute force attack? any alternatives to auto rebuild only needed indexes? one thing what come in my mind is to create a stored procedure...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
November 13, 2014 at 7:37 am
Stuart Davies (11/12/2014)
SQLRNNR (11/12/2014)
hjp (11/12/2014)
SQLRNNR (11/12/2014)
Impossible. There are multiple correct answers.JK
Ducks and runs - snigger.:-D:-D:-D:hehe:
Like... what?? If you don't present your case and argue why you think so, then...
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
November 12, 2014 at 10:32 am
hjp (11/12/2014)
SQLRNNR (11/12/2014)
Impossible. There are multiple correct answers.JK
Ducks and runs - snigger.:-D:-D:-D:hehe:
Like... what?? If you don't present your case and argue why you think so, then why bother writing...
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
November 12, 2014 at 9:24 am
zahid.nawaz (11/12/2014)
I have a small database of CMS system which does not have any primary key, relations or cluster indexes. few none cluster indexes has been created from vendor....
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
November 12, 2014 at 8:58 am
Impossible. There are multiple correct answers.
JK
Ducks and runs - snigger.:-D:-D:-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
November 12, 2014 at 7:36 am
succubus
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
November 11, 2014 at 11:05 am
djj (11/11/2014)
Ed Wagner (11/11/2014)
Stuart Davies (11/11/2014)
SQLRNNR (11/10/2014)
Stuart Davies (11/10/2014)
Ed Wagner (11/10/2014)
Stuart Davies (11/10/2014)
crookj (11/10/2014)
SQLRNNR (11/10/2014)
Ed Wagner (11/8/2014)
crookj (11/7/2014)
SQLRNNR (11/7/2014)
prison stripesSteelers SUCKY uniform (Honey Bee Stripes).
Referee
tree
House
Horror
Film
Buff
Vampire Slayer
Captain Kronos
Syndrome
China
Chyna
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
November 11, 2014 at 8:16 am
Stuart Davies (11/10/2014)
Ed Wagner (11/10/2014)
Stuart Davies (11/10/2014)
crookj (11/10/2014)
SQLRNNR (11/10/2014)
Ed Wagner (11/8/2014)
crookj (11/7/2014)
SQLRNNR (11/7/2014)
prison stripesSteelers SUCKY uniform (Honey Bee Stripes).
Referee
tree
House
Horror
Film
Buff
Vampire Slayer
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
November 10, 2014 at 3:41 pm
Ed Wagner (11/8/2014)
crookj (11/7/2014)
SQLRNNR (11/7/2014)
prison stripesSteelers SUCKY uniform (Honey Bee Stripes).
Referee
tree
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
November 10, 2014 at 8:11 am
Here is another good reference on the topic
http://sqlity.net/en/2427/backup-asymmetric-key/
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
November 9, 2014 at 2:00 pm
prison stripes
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
November 7, 2014 at 10:42 am
Koen Verbeeck (11/6/2014)
Then I remember the default for the flat...
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
November 6, 2014 at 8:07 am
Viewing 15 posts - 1,831 through 1,845 (of 19,560 total)