Viewing 15 posts - 13,606 through 13,620 (of 19,560 total)
davidshephard (6/10/2010)
use galacticwhere @customernumber = 263722
exec stp_deliverystatus
Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'where'
Use galactic is to switch database context.
In order to use the where...
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
June 10, 2010 at 2:55 pm
nelsonj-902869 (6/10/2010)
michael.kaufmann (6/10/2010)
Very interesting behavior--especially given the fact that BOL states one cannot set the MODEL database to READ_ONLY (that's why I did...
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
June 10, 2010 at 2:48 pm
charipg (6/10/2010)
so many jobs running under the owner as SA, will it be any problem if i change the sa password?
I have created a login with sysadmin...
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
June 10, 2010 at 2:48 pm
Lynn Pettis (6/10/2010)
CirquedeSQLeil (6/10/2010)
Lynn Pettis (6/10/2010)
Here, however, is my...
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
June 10, 2010 at 2:46 pm
In addition to what Lynn has mentioned, you should look at free space vs. used space in your database. Despite having grown to 17GB, you may not be using...
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
June 10, 2010 at 2:30 pm
Unfortunately as Homebrew said, if any apps are using it you will need to change the apps first.
Despite the fact that it is bad practice to use SA for everything,...
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
June 10, 2010 at 2:24 pm
Lynn Pettis (6/10/2010)
Here, however, is my two-cents.
Soccer is 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
June 10, 2010 at 2:20 pm
Yes you can have both on the same box. I currently have 2000, 2005, and 2008 on the same machine.
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
June 10, 2010 at 1:15 pm
laddu4700 (6/10/2010)
ldf are fine. I need to shrink mdf inorder to release some space
You only have 8Mb space free in your mdf. I don't think that is going 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
June 10, 2010 at 1:12 pm
Lutz has done better than I. I am not sure I understand your requirements based on what you posted. Could you elaborate, and also provide samples of what...
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
June 10, 2010 at 1:09 pm
I agree with Lowell, don't use this anywhere except for a test environment for the time being. You will need to clearly define the connection requirements and how it...
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
June 10, 2010 at 1:06 pm
Steve Jones - Editor (6/10/2010)
We should also be embarrassed if we lose at basketball.
I was. But then again - look at the components of those teams that have lost.
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
June 10, 2010 at 11:20 am
Pure Awesomeness.
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
June 10, 2010 at 10:52 am
Steve Jones - Editor (6/10/2010)
Hmmm, would you get a new level at 1433? Or before it? Do I change on 1434 or 1435 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
June 10, 2010 at 10:30 am
Just Curious - why don't we have a level for 1433?
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
June 10, 2010 at 10:23 am
Viewing 15 posts - 13,606 through 13,620 (of 19,560 total)