Viewing 15 posts - 15,526 through 15,540 (of 19,560 total)
What is your backup schedule?
Weekly full, and then daily diff? Something else?
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
April 1, 2010 at 5:27 pm
GregoryF (4/1/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
April 1, 2010 at 5:24 pm
I agree that it is more complicated.
Imagine the implications of having a 1TB database, would you also have 1TB of memory?
Your max memory setting would not correlate to aggregate of...
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
April 1, 2010 at 5:22 pm
Karl Kieninger (4/1/2010)
Currently the remote server is sql server 2000. Would this resolve itself with 2005 or 2008 on the remote?
There is a high probability of it self-resolving by upgrading....
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
April 1, 2010 at 5:15 pm
Chad Crawford (4/1/2010)
CirquedeSQLeil (4/1/2010)
Chad Crawford (3/30/2010)
Dear Friend Master SQL Guru, 😀Ha, I just barely noticed that.
Dedicated lurker there. Haven't missed a post for at least a year!...
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
April 1, 2010 at 5:05 pm
Trey Staker (4/1/2010)
CirquedeSQLeil (4/1/2010)
Trey Staker (4/1/2010)
I...
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
April 1, 2010 at 5:00 pm
rainleta (4/1/2010)
CirquedeSQLeil (4/1/2010)
rainleta (4/1/2010)
CirquedeSQLeil (4/1/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
April 1, 2010 at 4:58 pm
I have an excellent script for that. I also have a blog post explaining the workings of the script.
Check it out at:
http://jasonbrimhall.info/?p=263
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
April 1, 2010 at 4:23 pm
mojo-168709 (4/1/2010)
I'm a bit confused with a wrong answer, hence 7 points. If the question is categorized as humorous, how could it be a wrong answer, then? A wrong humor?
Even...
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
April 1, 2010 at 4:18 pm
rainleta (4/1/2010)
CirquedeSQLeil (4/1/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
April 1, 2010 at 4:13 pm
Looks like Paul has improved his daily post average.
He is now at 100.9333 posts a day.
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
April 1, 2010 at 4:12 pm
Paul Randal (4/1/2010)
JasonRowland (4/1/2010)
Thanks for the...
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
April 1, 2010 at 4:10 pm
Garadin (4/1/2010)
Also, have you checked the index usage DMV to see if all of those 20 indexes are actually being used?? Have you compared their create scripts to see if...
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
April 1, 2010 at 4:08 pm
In that article I gave it discusses how the Browser Service is used for Named Instances. If you specify a different than default port for the default instance 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
April 1, 2010 at 3:54 pm
Correct. As a SQL Server Database professional. It shouldn't matter that you are a developer, BI Specialist, or Admin. Working with SQL Server is the important underscore.
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
April 1, 2010 at 3:40 pm
Viewing 15 posts - 15,526 through 15,540 (of 19,560 total)