Viewing 15 posts - 8,371 through 8,385 (of 19,560 total)
Sapen (10/6/2011)
Hope all is well.
I have a situation where I am seeing that the size of the indexes that I have on my production db is equal to or...
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
October 6, 2011 at 9:01 pm
You need to be able to login with an account that has security admin or sysadmin access.
What login did you use to change the logins to the public role in...
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
October 6, 2011 at 8:59 pm
So far so good - everybody has answered correctly thus far. 6/6
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
October 6, 2011 at 8:56 pm
SKYBVI (10/6/2011)
I am trying to enter an application on a client PC, (application is MS Dynamics GP which uses sql server logins)
When I try 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
October 6, 2011 at 8:53 pm
Jack Corbett (10/6/2011)
create view SYSTEM_DATE_VIEW
as select getdate() SYSTEM_DATE
...
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
October 6, 2011 at 12:55 pm
Sean Lange (10/6/2011)
Jack Corbett (10/6/2011)
Never really listened 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
October 6, 2011 at 12:34 pm
GilaMonster (10/6/2011)
Stefan Krzywicki (10/6/2011)
GilaMonster (10/6/2011)
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that...
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
October 6, 2011 at 12:31 pm
Ninja's_RGR'us (10/6/2011)
Grant Fritchey (10/6/2011)
Steve Jones - SSC Editor (10/6/2011)
A sad day, and a reminder that I'm getting older as...
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
October 6, 2011 at 11:47 am
Good to hear.
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
October 6, 2011 at 11:38 am
michael.kaufmann (10/6/2011)
SQLRNNR (10/6/2011)
Thanks for the question. I would like to see a table that has needed that many indexes.
I'd guess Microsoft increased this number with the introduction of filtered...
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
October 6, 2011 at 9:07 am
scared
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
October 6, 2011 at 8:53 am
I like how vulcan has a disturbing smile:unsure:
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
October 6, 2011 at 8:52 am
bitbucket-25253 (10/5/2011)
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
October 6, 2011 at 8:34 am
Thanks for the question. I would like to see a table that has needed that many indexes.
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
October 6, 2011 at 8:31 am
Thanks for the question Tom.
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
October 6, 2011 at 8:29 am
Viewing 15 posts - 8,371 through 8,385 (of 19,560 total)