Right click in your query window.

click Include Actual Execution Plan

when you execute the query next there will be an addition info that shows the Graphical query execution plan.

you probably could...

Read this article by Paul Randal on logging and recovery

http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx

then check your database recovery model.

before you execute your statement type in the following command

dbcc sqlperf(logspace)

and check how full ...

Sorry to be the kiss @$$ looking for an "A" 😀

but only non-clustered indexes can be filtered

Creates a filtered index by specifying which rows to include in the index. The...

When you take a look at the execution plan what do you see?

Hey Theo,

I get what your saying, my suggestion would be a custom coding job. You have an app or a web page that has a button...

*sorry hit the tab button and enter before i finished typing:-D

sorry for being brief I don't have time to work up a script but i know you can execute a job through script, however you would need to work up...

NJ-DBA (7/15/2010)

---

Hi Folks,

I currently have a 2005 Cluster with a single default instance. I would like to add a second (named) instance to the cluster. I do not...

Tim-153783 (7/19/2010)

---

You should also make sure that the account running the sql server service has the local security policy right, Perform Volume Maintenance Tasks. This will allow for...

This is straight from Paul Randal's blog that another user posted a link to abover

PS To address...

The is a great TDE...

mattr-846241 (6/29/2010)

---

One way performance could be affected is if you use temporary tables. You may have a database which has a stored procedure which uses a temporary table.

I think...

I agree with everyone else.

I went to the link on MSDN to read about this, and it says basically that it "might" have an impact.

I've read the article as well...

here is a script I use to see database stats

declare @myTable as table (

[myID] [int] IDENTITY(1,1) NOT NULL,

fileid varchar(4),

fileGroup varchar(4),

TotalExtents int,

usedExtents int,

DBName varchar(100),

filename1 varchar(max))

insert into @myTable

exec ('sp_msforeachdb @command1="use [?];...

Hey Just went through this myself.

Here is the best thing I found on the net

http://www.mssqltips.com/tip.asp?tip=1687

I made my own step by step guide, but this was the foundation.

I read the white...