Viewing 15 posts - 19,411 through 19,425 (of 19,560 total)
I would like to be able to attend more sessions. Looks like a lot of good stuff being presented.
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
September 1, 2009 at 11:17 am
I'm sure there is. If not in Jersey then maybe in the Big Apple. Google should be able to bring up plenty of results for your area.
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
September 1, 2009 at 11:06 am
The question asks for the "best" thing to do. Probably should have been worded as "will give the most performance boost."
I would not use Raid 0 by itself.
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
September 1, 2009 at 10:54 am
Jeff Moden (8/31/2009)
CirquedeSQLeil (8/31/2009)
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
August 31, 2009 at 5:26 pm
Learned something from this one - nearly 5 yrs after it was originally asked.
Decided to test it since the clue was in the question and the size limits were there.
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
August 31, 2009 at 4:51 pm
Maybe it is because i am late on this one, but according to Technet
http://support.microsoft.com/kb/274750
The max addressable with SQL Server and W2K Data Center is 32GB
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
August 31, 2009 at 4:47 pm
Does that particular user have any other processes running?
I have seen in the past where a user was connected via SSMS and the Application showed as Microsoft SQL Server. ...
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
August 31, 2009 at 4:36 pm
Try to login to the database using SSMS with the webuser and see if that works.
If you are not able to get in, check to see if the user might...
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
August 31, 2009 at 4:21 pm
Michael Valentine Jones (8/31/2009)
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
August 31, 2009 at 4:15 pm
With so many tables, and the size of DB included, something I have done is to create multiple filegroups. I separate the tables out into these filegroups and 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
August 31, 2009 at 4:07 pm
Jeffrey Williams (8/31/2009)
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
August 31, 2009 at 3:41 pm
Corporate policy may decree it, but there should be some controls in place allowing end-users a little freedom to finish up the current task. It doesn't help the company...
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
August 31, 2009 at 3:28 pm
Unfortunately, I think I have a dupe in the system too. I think mine happened on initial account creation. I only registered once many years ago 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
August 31, 2009 at 3:09 pm
Thanks Steve. Looks like I may have to test Win 7 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
August 31, 2009 at 3:04 pm
Steve,
So would you recommend Win 7 over Win XP, Vista, or both?
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
August 31, 2009 at 12:48 pm
Viewing 15 posts - 19,411 through 19,425 (of 19,560 total)