Toreador (10/27/2010)

---

Hugo Kornelis (10/27/2010)

---

For the datetime data type, The only formats that are guaranteed to work correctly in all circumstances are:

* yyyymmdd - for dates without time portion. No dashes....

Ray K (10/26/2010)

---

Speaking as someone who has collegiate...

Thee is no built in limitation of SQL Server that would prevent it.

It will all come down to proper DB design, efficient ETL design, and making sure you have adequate...

The is probably nothing that can't be done by adding brackets around the name: [db name]

However, it is likely the many utilities may not work very well with this type...

Small college sports are a very cheap day out.

I went to a football game a couple of weeks ago at a local college:

1. No change for admission or parking.

2. Tailgating...

You should set your transaction log backups to run more often: every 15 minutes 24x7 is a good standard.

That will let you find out exactly when it is happening, and...

SP_UPDATESTATS only updates the statistics where it thinks it needs to.

Make sure you follow that code the way I posted it after editing, because I initially posted it wrong. I have tested this several times:

Just to go through it...

Brandie Tarvin (10/26/2010)

---

Edit: Changing my answer.

It's a semi-good point. A user with every other permission cannot grant herself sysadmin access even when she has SecurityAdmin perms. Which is good from...

Brandie Tarvin (10/26/2010)

---

Thanks, Michael. I know what the fixed server roles do. What I'm trying to figure out is what they might not cover that would be necessary for a...

5/2 is integer math, so it produces integer results, and has nothing to do with how the ceiling function works. See the example below for what is happening.

select x...

If you are use the new DATETIME2 data types, you can use SYSDATETIME or SYSUTCDATETIME to get a more precise value. There is no real penalty for using DATETIME2,...

Create the date table and then setup a SQL Server job to add new rows as needed.

However, why don't you just setup a date table and add rows for many...

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

http://www.sqlservercentral.com/articles/Administration/68271/

http://www.sqlservercentral.com/Forums/Topic812701-471-1.aspx

securityadmin would be enough to get me anything else I needed.

From SQL Server 2008 BOL:

"securityadmin:

Members of the securityadmin fixed server role manage logins and their properties. They can GRANT, DENY,...