It's probably easier to just not create databases with a trailing space in the name.

GilaMonster (5/18/2011)

---

Alter index on each nonclustered index or ALTER INDEX ALL On <table>

Heaps cannot be rebuilt in SQL 2005.

Someone is sure to suggest adding and dropping a clustered index. While...

If your application is expecting 150 columns and you add a column to the table it will probably break when it is suddenly starts getting 151 columns.

You can calculate the Tuesday after the last Friday of the month using the logic below. For the current date, just replace a.DATE from the calendar table with GETDATE()....

The solutions posted using sign will not work correctly if the value is negative.

Also, they need to account for the possibility that all four columns are null.

create table #table

(col1...

Did you restart SQL Server after setting lock pages in memory?

How large is the database actual space used in the data files?

Stringzz (5/12/2011)

---

I need to update employee id's in our HR database. The problem is there are a lot of primary and foreign keys in the tables in the database. I...

Are you running Windows Standard or Enterprise Edition? If you are running Windows Standard Edition, you will not be able to access 6 GB of memory.

From SQL Server 2005...

It can be used any time a logical condition is needed that should always be true.

while 1=1

begin

if SomeLogicalCondition

break -- to exit while loop

end

You cannot change an existing column to identity.

You can create a new table with the identity attribute set on the column you want and copy the data from the old...

Probably better to ask a lawyer about something like that.

You might consider defaulting the PK columns with the NEWSEQUENTIALID() function to minimize the page splits as you insert data.

create table myTable

(

ColumnA uniqueidentifier not null DEFAULT NEWSEQUENTIALID() primary key...

Visa

buddy__a (5/5/2011)

---

My script s designed to update an existing database so I need to check for existence first. It's an indexed view so I don't really want to drop...

if 1=1

begin

exec('

create view dbo.test

as

select * from sometable

'

end