No, I don't think this is possible in that direction. Probably the easiest way is to use DTS or BCP.

No, data pages and index pages are two different kind of things. Actually there are several different kinds of index pages.

- Leaf level für Nonclustered Indexes

- Non-Leaf level for...

Answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=155849

AFAIK, this information is stored in the registry, so it takes effect immediately. There should be no need to restart the server.

Did you read the link I've posted?

See, if this helps:

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

See, if this helps:

http://www.karaszi.com/sqlserver/info_generate_script.asp

Either that way or by adding other criteria to the WHERE clause. if the vendor has certain patterns in his naming convention. Anyway, I mentioned it's a basic construct and...

The magic phrase here is "Dynamic SQL" and is something you should avoid, if possible. Read http://www.sommarskog.se/dynamic_sql.html and decide if that is your way to go.

I never manage to get deeper into why this is, but consider this:

DECLARE @hex VARCHAR(10)

DECLARE @stmt NVARCHAR(255)

DECLARE @int INT

SET @hex = '0x0000008A'

SELECT @stmt = N'SELECT @int = CONVERT(...

What are the underlying data types look like?

And are there NULLs present?

The 18 birthday might be not the best example. Marriage, Birth of children, Divorce (nono... no particular order here ) are maybe...

one last thing, can you recommend any good books/sites for WMI querying, as I clearly do not know enough about it. (or anything at all, in fact!)

Maybe this will help:...

IMO, the use of filegroups complicates mostly things. Unless you don't have a DB > 1 TB I would leave it in one filegroup and place this over as many...

No, you do not want to destroy First Normal Form.   Read **ANY** book on RDBMS basics for a description of normal forms.  Read **ANY** book on tiered architectures, which will...