Viewing 15 posts - 15,721 through 15,735 (of 19,560 total)
WayneS (3/30/2010)
CirquedeSQLeil (3/30/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 30, 2010 at 9:43 pm
If the file is not there then somebody or some process has deleted if the backup completed successfully.
I would certainly verify that auditing is on for that fileshare and check...
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 30, 2010 at 6:51 pm
Magy (3/30/2010)
So I guess I could do this?
SELECT * FROM myTable
WHERE 1 = 1
select case @myVar
WHEN 1 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
March 30, 2010 at 6:49 pm
Have you tried using a left outer join for this query in lieu of the inner joins?
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 30, 2010 at 6:46 pm
I would shrink the log file first. After the log file is shrunk an properly sized, then do the move.
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 30, 2010 at 6:05 pm
Jack Corbett (3/30/2010)
Paul White NZ (3/30/2010)
CirquedeSQLeil (3/30/2010)
That to me is akin to calling PaulPaulster
Never do that again. I will find you.
:w00t:
A little intense there hey, Paulie? 😀
Careful -...
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 30, 2010 at 5:55 pm
sgambale (3/30/2010)
I wound...
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 30, 2010 at 4:07 pm
Thanks for posting back.
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 30, 2010 at 4:05 pm
Is this still an issue?
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 30, 2010 at 4:02 pm
Lynn,
Do you have any other jobs or processes that may be trying to fire it off? I ask because I have a ton of jobs that are setup in...
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 30, 2010 at 3:58 pm
10% fragmentation seems like an awfully low threshold. I've been in environments where we didn't touch it unless it was 50% (1TB plus databases). Then we would defrag...
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 30, 2010 at 3:38 pm
Have a look at this article on PieceMeal restores:
http://msdn.microsoft.com/en-us/library/ms177425.aspx
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 30, 2010 at 3:31 pm
The most preferred by Canadians is "CanoBeer" 😀
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 30, 2010 at 3:25 pm
In answer to your question about imaging the database - yes it can be done. I wouldn't do it until after the computer name as been changed as stated...
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 30, 2010 at 3:21 pm
Ok, now that is beyond too far. Having a festival for the oysters. Think of all the lambs.
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 30, 2010 at 3:14 pm
Viewing 15 posts - 15,721 through 15,735 (of 19,560 total)