Viewing 15 posts - 736 through 750 (of 956 total)
Capacity planning is about knowing the trend in growth over time. You need to monitor how the free space in the data files is changing. I log this...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 5, 2008 at 8:20 am
Don,
Something happened to your report, but all that came through were the select statements. Can you repost the blocked process report?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 5, 2008 at 8:05 am
I agree that SSIS is generally going to be the tool that you would use for doing data transfers in almost all cases. It didn't fit our companies business...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 9:40 am
Jean-François Bergeron (12/4/2008)
P.S. Lynn, Thanks for the script, I like the idea with the log backup,
I agree that is a nifty script, and I will have to add that to...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 9:26 am
Jean-François Bergeron (12/4/2008)
Jonathan Kehayias (12/4/2008)
It has a much smaller footprint, and if you kill it, the rollback segment is limited to the current 1000 rows being affected.
Does that...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 9:20 am
Simon Smith (12/4/2008)
Can you not just save the records you want into a temp table and then truncate ?
If you can swing this kind of operation, it is generally much...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 9:17 am
The difference is that you are issuing thousands of smaller transactions affecting 1000 rows at a time versus issuing a single transaction that is affecting millions of rows. The...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 9:10 am
You can delete them in small batches in a loop like the following:
DECLARE @BatchSize INT,
@Criteria DATETIME,
...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 8:49 am
You can use SSIS and the Transfer Logins Task to move logins between Servers. You should probably use a Active Directory Group to control grouping of logins.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 8:00 am
PASS = Professional Association for SQL Server
It is a organization for SQL Server Professionals that is worldwide and membership is free. They do the PASS Summit every year which...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 7:33 am
That is a big question and one open to alot of opinion. I'd recommend that your read the following articles on this site:
http://www.sqlservercentral.com/articles/Administration/61680/
http://www.sqlservercentral.com/articles/Administration/61681/
http://www.sqlservercentral.com/articles/Career/61535/
https://www.sqlservercentral.com/blogs/brian_kelley/archive/2007/10/29/3075.aspx
http://www.sqlservercentral.com/articles/Editorial/62696/
http://www.sqlservercentral.com/articles/Editorial/62928/
http://www.sqlservercentral.com/articles/Editorial/62865/
Also look at Kimberly Tripps post on...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 7:14 am
You can probably find most of the information that you are looking for on Pinal Daves blog. He has 58 posts dedicated to Interview Questions and Answers:
http://blog.sqlauthority.com/category/main/sql-interview-questions-and-answers/
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 7:04 am
Here is what Microsoft considers to be the top 30:
http://www.microsoft.com/sqlserver/2005/en/us/top-30-features.aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 7:01 am
If it is a detached copy of the same database, you could attach it with a different name and get a copy of the table and whatever contents existed at...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 4, 2008 at 6:52 am
We do similar things with our DMZ Servers, so the topic is very familiar. I have to setup a PC every month or so for one reason or another.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 3, 2008 at 7:43 pm
Viewing 15 posts - 736 through 750 (of 956 total)