Check out this discussion:

http://www.sqlservercentral.com/Forums/Topic470379-338-1.aspx

Has a whole bunch of solutions, tests, etc., for this topic.

Not just missing indexes. Can also be indexes that are so fragmented or where the statistics are so badly out-of-date, that the engine doesn't use them. Can also...

Then you need to add a declaration for @Level10 to the string, and an assignment.

Something like:

set @sql = 'declare @Level10 bit; set @Level10 = ' + cast(@Level10 as char(1)) +...

If the file is too big to open, I'm not sure what to do with it. Maybe someone who knows XML a bit better will be able to help...

You declare @Level10 in the code that creates the dynamic SQL, but not in the dynamic SQL string. If you want to use it in the SQL string, you...

By default, the primary key is the clustered index. When you create the table, you can specify "nonclustered" on the PK row, which will override that default. If...

I tried to attend the webinar today (the one yesterday was "out of room" when I tried to sign up for it). Got into the conference call without difficulty,...

I have SQL 2005 Dev running on Vista Home Premium (at home, of course), so it can be made to work. Here are some steps I had to go...

The way to do this depends on the purpose of doing this. If the idea is to reduce drive space use on the main server, you handle it differently...

Am I understanding correctly that you have one huge file, but that it can be broken down into 40k smaller files, and that the huge file is too big to...

jezemine (7/14/2008)

---

GSquared (7/14/2008)

---

"how can use a bulldozer to separate two stacks of firewood, without turning the buldozer on, if your hands have been burned off and you've got a terminal...

You can use a bunch of different methods to get the time off the datetime.

dateadd(day, datediff(day, 0, getdate()), 0)

Is the one I generally use these days.

I generally use SSIS to bulk export them to a .txt file, then move that, then use SSIS to bulk import it. Then use a checksum to verify that...

The problem with so-called "analytical problems" is that so very many of them aren't analytical at all, they are based on trivia.

For example, the lamps one. Because it's been...

Usually, NT domain users are assigned to SQL Servers and databases as parts of groups. The individual login might not be there. Check under the Users tab for...