Viewing 15 posts - 9,916 through 9,930 (of 19,560 total)
The Dixie Flatline (6/1/2011)
May have to shut it for quite a long time too 😉
However long it takes.
Your running rhino icon looks naked, Jason.
Would you...
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 1, 2011 at 12:43 pm
The Dixie Flatline (6/1/2011)
Insert your random cursors where you wish, change the variables and attach speech to the output.
Shut the front door....
May have to shut it for quite a long...
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 1, 2011 at 11:43 am
What do you see in the job history for that particular job?
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 1, 2011 at 11:42 am
I agree with Ninja. It will depend on the data and how much you will need to store.
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 1, 2011 at 10:39 am
Jim Murphy (6/1/2011)
The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte
Brings me back to the beginning of 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 1, 2011 at 9:58 am
The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte
I'm more inclined to go with something like this:
DECLARE @numrows...
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 1, 2011 at 9:41 am
The Dixie Flatline (6/1/2011)
Would you call this recursive?
WITH cte (Curse) AS
(
SELECT 'Dammit'
UNION ALL
SELECT Curse from cte
)
select Curse from cte
Yes - but just not enough
;
WITH cte (Curse) AS
(
SELECT...
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 1, 2011 at 9:37 am
Do you have another job that executed that snapshot job?
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 1, 2011 at 9:15 am
Are you running this from debug mode? Are you getting any errors?
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 1, 2011 at 8:55 am
dts (import export), bulk copy, ssis package, or use a redgate data compare tool to compare the tables of the database that is running on a 64 bit machine 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 1, 2011 at 8:43 am
The number of files in your tempdb depends on your needs, hardware and usage. One consideration though is that it would be more common to have 8 data files...
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 1, 2011 at 8:40 am
Nice back to basics type of question. Thanks
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 1, 2011 at 8:31 am
Greg Edwards-268690 (6/1/2011)
Dave Ballantyne (6/1/2011)
mazzz (6/1/2011)
The RBAR way of asking a question...?
QBAQ , i like it 🙂
:-P:-P:-P
CTE or Cursor?
Definitely a while loop
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 1, 2011 at 8:18 am
Autogrow should only be a "fail-safe" type of operation at best. One big reason that many prefer not to allow autogrow is the heavy IO cost that comes with...
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
May 31, 2011 at 10:23 pm
Thanks for the question.
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
May 31, 2011 at 1:13 pm
Viewing 15 posts - 9,916 through 9,930 (of 19,560 total)