Viewing 15 posts - 16,216 through 16,230 (of 19,560 total)
Paul White NZ (3/18/2010)
CirquedeSQLeil (3/18/2010)
I am curious why you changed your alias to include NZ.
Several reasons, mostly consistency. I am registered with that name on other forum-type sites, and...
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
March 18, 2010 at 11:44 pm
Jeffrey Williams-493691 (3/18/2010)
CirquedeSQLeil (3/18/2010)In a sinisterly maniacal way.:sick:
Yes - but that is what would be so much fun 😀
Passing it off to the Junior and watching the Jr 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
March 18, 2010 at 9:45 pm
You're welcome.
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
March 18, 2010 at 9:09 pm
Jeffrey Williams-493691 (3/18/2010)
Could be lots of fun :hehe:
In a sinisterly maniacal way.:sick:
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
March 18, 2010 at 9:09 pm
You're welcome.
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
March 18, 2010 at 9:08 pm
sql-lover (3/18/2010)
I think Jeff hit it on the head here. SQL 2008 is more explicit in it's permissions than was SQL2005. With that, it is also more secure...
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
March 18, 2010 at 8:05 pm
You're welcome.
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
March 18, 2010 at 8:02 pm
Mr J (3/18/2010)
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
March 18, 2010 at 8:01 pm
The sql agent is programmed to look at the msdb database. I don't think there is any way around the situation. You will need to rename the dup...
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
March 18, 2010 at 6:41 pm
Olga B (3/18/2010)
One SQL Server box. Two instances - SQL 2005 (main) and SQL 2000 (named) - both run under the same domain account, as do...
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
March 18, 2010 at 6:36 pm
The Dixie Flatline (3/18/2010)
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
March 18, 2010 at 5:43 pm
Is this more suitable?
Declare @QtdRptEarnSubjDed00varchar(10)
,@QtdRptEarnSubjDed01varchar(10)
,@QtdRptEarnSubjDed02varchar(10)
,@diffvarchar(10)
Select @QtdRptEarnSubjDed00 = 0,@QtdRptEarnSubjDed01=0,@QtdRptEarnSubjDed02=1,@diff=20
Declare @sqlvarchar(max)
Set @sql = 'UPDATE SOMETABLE
SET ' + case WHEN @QtdRptEarnSubjDed00 > 0
THEN 'QtdRptEarnSubjDed00'
When...
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
March 18, 2010 at 5:41 pm
I recommend you check out how to use the import export tools in SSMS. You can also look at learning SSIS to perform the same task or you could...
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
March 18, 2010 at 4:57 pm
Nevermind - I finally found 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
March 18, 2010 at 4:56 pm
This may be of use as well
SELECT SERVERPROPERTY ('edition'),serverproperty('productversion')
Eliminate the string building.
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
March 18, 2010 at 4:55 pm
Viewing 15 posts - 16,216 through 16,230 (of 19,560 total)