DBAgal (8/23/2010)

---

Hi all -

I just wanted to see what people's opinions were on this subject. Here's the info:

My current goal is to move all of my databases to...

Jeff Moden (8/21/2010)

---

GilaMonster (8/20/2010)

---

Now...

It is going to depend upon what the organization expects from the DBA's. If all you are doing is production support, then a single DBA could handle all of...

This is really useful when bulk loading data into a DW. When you bulk load the data, you can DISABLE all of the non clustered indexes, load the data,...

sql_er (8/21/2010)

---

Hi,

I work with MSSQL 2000. When creating tables I never paid attention to the order and type of columns. Last week a co-worker mentioned that it is...

The default settings of the SQL Server Agent is usually not adequate. There are two options in that dialog, the first one defines how many rows will be kept...

Rajat Jaiswal-337252 (8/16/2010)

---

Hi Thanks Jeffery,

I just want to reduce log file size because there is size issue on my production database drive.

and the log become 20 GB to 30 GB...

Rajat,

I am still confused as to why you think you need to shrink the log file at all. The size of the log file has no bearing on log...

Unless there is a specific reason you need to use separate service accounts for each service - I don't usually do that. I'll create a single service account for...

The simplest and fastest (for me), is to just open a query window and start typing.

Now, if this is a case where the user is not really sure what the...

I would create a stored procedure that loops continuously - and put in a WAITFOR DELAY.

Then, create a SQL Agent job that checks to see if the process is started...

The two statements are not equivalent - combining them could eliminate those rows that don't match the second queries criteria, and those rows wouldn't be updated.

To make sure you can...

That is correct - SQL Server 2008 does not add the BUILTIN\Administrators to SQL Server. This is a security measure to prevent local administrators of the machine from automatically...

Use configuration manager to restart the services. You can use SSMSE - if you run it as administrator.

Review the article I link to in my signature - it explains all of this very well.

Truncation makes space in the log file available to be reused. Truncation happens...