Haven't tried it with SQL 2008 but with 2005 it is possible, though...

I don't remember the exact screen, but when you select the features to install click on advanced and then I think when selecting the Database Engine there's the possibility to...

Gaby A. (1/13/2009)

---

MarkusB (1/13/2009)

---

I just did some testing myself and even though I can't find anything in the official documentation it seems like the function get_sid() has been removed from...

I just did some testing myself and even though I can't find anything in the official documentation it seems like the function get_sid() has been removed from SQL 2005 or...

No, I don't know how exactly DTA determines which indexes it recommends and I only use it occassionally.

But you say you wouldn't come up with the recommended index and...

Yes, it's one of the less known function, but when it comes to working with Ip-addresses it's...

Unfortunately you don't write if you're using the 32-bit o 64-bit version. On the 32-bit version you need to enable AWE in SQL Server to address more than 4 GB...

This will work

DECLARE @file VARCHAR(100)

SET @file = 'D:\backup\databasename\Backupname.bak'

SELECT LEFT(@file, LEN(@file) - CHARINDEX('\',REVERSE(@file)))

Another possiblitity is this:

DECLARE @ip_part VARCHAR(15)

SET @ip_part = '192.168.0.27'

SELECT PARSENAME(@ip_part, 1)

I think this is the article you're looking for http://www.sqlservercentral.com/articles/Administration/64732/

sp_spaceused can be inaccurate, unless you execute DBCC UPDATEUSAGE before.

See BOL for more info.

Error 112 usually indicates that there's not enough space on the disk.

I'm a bit confused about whay you were doing.

You say you restored from a .bak file and then attached the files? Normaaly when you restore from a .bak file there's...

It's a good and simple tool, but you have to know how to use it.

Here are two useful articles:

http://www.sqlteam.com/article/benchmarking-disk-io-performance-size-matters

http://sqlblog.com/blogs/linchi_shea/archive/2007/02/21/parse-the-sqlio-exe-output.aspx

DBCC PINTABLE actually has no effect in SQL 2005.

It's one of the discontinued commands in 2005.