Viewing 15 posts - 18,826 through 18,840 (of 19,560 total)
Sunny
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
December 9, 2009 at 5:52 pm
Totally agree. I am doing the back questions to hone up a bit. There are some nitpicky things in some of the questions that make you have 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
December 9, 2009 at 5:51 pm
I agree with the previous post on this one. The default for Reporting Services 2000 was for pageheight to be in Inches and the height would have been 11...
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
December 9, 2009 at 3:36 pm
RBarryYoung (3/15/2008)
It is really disturbing how many wrong answers there are. It also makes me wonder how the folks with over 90% right ar doing...
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
December 9, 2009 at 2:50 pm
Have you considered using a maintenance plan, or an SSIS package to do this?
Both seem like viable alternatives as well (in addition to Steve's suggestion).
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
December 9, 2009 at 2:39 pm
try using xcopy with a command to delete
or you can do a dir to parse the filename and date info into a temp table and then do a move based...
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
December 9, 2009 at 1:44 pm
Lynn Pettis (12/9/2009)
with CombinedData as (
select
row_number() over (partition by ItemId order by LocationDateTime asc) as RowNum,
ItemId,
...
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
December 9, 2009 at 1:31 pm
Lynn Pettis (12/9/2009)
How the .... did this person get a job in IT?????
This guy has been a frequent post-er today
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
December 9, 2009 at 1:02 pm
Better yet, have the user start using Windows Authentication instead of SQL Auth. Then the user will be using windows credentials. If the user can't remember the password...
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
December 9, 2009 at 1:00 pm
Some reading on the subject:
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
December 9, 2009 at 12:57 pm
Nice query, I am playing with it now and adapting to my needs. Seeing if I can take it to the level of overkill 😀
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
December 9, 2009 at 12:52 pm
Lynn Pettis (12/9/2009)
jcrawf02 (12/9/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
December 9, 2009 at 12:05 pm
To follow up on what Gail said, (and make it very obvious)
Declare @NewBody Varchar(100)
Set @NewBody = 'A record with id ' + d.id + ' has been updated'
--Note: 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
December 9, 2009 at 11:04 am
Lynn Pettis (12/9/2009)
I'm trying to help, but any time I try to write something about...
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
December 9, 2009 at 10:47 am
Use the brackets [ and ].
Or click on the IfCode to the left that has code="sql" with the brackets.
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
December 9, 2009 at 10:14 am
Viewing 15 posts - 18,826 through 18,840 (of 19,560 total)