Is DATENAME not something you want?

You're not really describing this well, either in your first post or this last one.

I'm not quite clear what you are doing here.

Can you provide a short sample of test data and the source? Is this is in a table or in XML for...

Syed Jahanzaib Bin hassan (4/28/2011)

---

I didnt say like this as you get ,snaphot database work with database which one is snaped shot,A database snapshot is a read-only, static view of...

I don't think that tempdb is ever redundant. It's used for a variety of things as mentioned above, and it isn't necessarily because of memory.

The restore syntax is the same. Not a big deal there. However the startup parameters for master might need to be changed in a DR situation. In the services applet,...

First, AFAIK, you cannot separate a table across filegroups. You can separate across files, but not filegroups. The exception is partitioning.

You can move a table's data to a new filegroup...

One thing to keep in mind, if you are looking for partial database recovery in a DR situation, moving the indexes away from the table can cause issues. Think about...

Jim has some good advice here. The main problem is trying to track the web user. If you move to requiring the person accessing the web site to log in,...

Do this:

set @sql = create login ' + @ip_newuser + ' with password = ''password'' ' ;

select @sql;

Take the output and look at it. Then try to run it manually...

If you have...

It depends on the developer. If...

And the organization of those objects. It looks like schema is another area where we've "reused" a word too many times.

The schema has always meant the design as well. What...

It's a fairly arbitrary concept and with conflicting information on the calculations, it's hard to understand what is correct. The way that it's given in the white paper, which is...

The schema affects query performance only in terms of how many joins you might need to perform queries, but any balancing out to reduce query time can increase resources to...

You have the logic there, just work through it.

First, check nickname. It it is null, then what? It looks like you are going a little too quickly with the logic....