Viewing 15 posts - 17,401 through 17,415 (of 19,560 total)
Are you able to get any results from the database query i provided?
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
February 10, 2010 at 10:42 pm
Lynn Pettis (2/10/2010)
Sounds reasonable. Curious, are the backups to local drives (DA or SAN) or to a network share?
Now that opens up an entirely new can of worms.
Ideally one...
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
February 10, 2010 at 7:26 pm
Is read count user distinct? Or can one artificially bloat the read count?
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
February 10, 2010 at 7:25 pm
That would be the one - NCIS.
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
February 10, 2010 at 7:21 pm
Must be part of the reason for pulling NewSID. Good information.
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
February 10, 2010 at 6:55 pm
Not really fond of the stick myself. I like the touchpad - but really prefer to just use a mouse. I do hate when the cursor jumps -...
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
February 10, 2010 at 5:05 pm
Same rules apply to service packs. Service packs will list the hotfixes involved in the SP. Read the kb's - test in dev and then promote through your environments...
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
February 10, 2010 at 4:49 pm
For cloned installs Microsoft has a tool that you could run to prevent the SID problem. Take a look at NewSID and SysPrep.
Thanks for posting back with the resolution.
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
February 10, 2010 at 4:45 pm
Here is a doc that covers the permissions needed for the service accounts.
Too few permissions and you could lose some functionality.
http://msdn.microsoft.com/en-us/library/ms143504.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
February 10, 2010 at 4:41 pm
You could also look on Lynns blog. He has some examples there of various datetime operations.
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
February 10, 2010 at 4:34 pm
Yes. I've seen it done before, tested the restores and it all worked. Thus 10 min is fine.
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
February 10, 2010 at 4:32 pm
MarlonRibunal (2/10/2010)
to return user tables and their columns:
-- Object Catalog
SELECT T.NAME AS , C.NAME AS [COLUMN...
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
February 10, 2010 at 4:23 pm
RBarryYoung (2/10/2010)
RBarryYoung (2/10/2010)
CirquedeSQLeil (2/10/2010)
Barry is in a smackdown mood today. That's two on the day.
Yeah, there's just something about feeling like I have a screwdriver jammed up my spine...
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
February 10, 2010 at 4:20 pm
RBarryYoung (2/10/2010)
Steve Jones - Editor (2/10/2010)
Barry,That response reminded me of the Super Bowl ad with everyone smacking the backs of people's heads.
which one was that? I can't seem 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
February 10, 2010 at 4:12 pm
I really need to get into doing SB and event notifications - that looks like a lot of fun. 😎
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
February 10, 2010 at 2:39 pm
Viewing 15 posts - 17,401 through 17,415 (of 19,560 total)