Or not as funny to others as to you and my wife.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

I use it on occassion.

I have seen issues where the security accounts that run SQL server change or the rights for those accounts change.

I just checked one of my...

Thanks, we appreciate the thanks and will keep working hard.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

At PASS some of the MS guys mentioned that at around 400/sec, identities become a bottleneck. GUIDs do not as there are routines optimized for their creation. Not sure...

None I'm aware of. Are you looking for something to review T-SQL code?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Likely a problem with the backup file. Can you take another?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Huge issue. DO NOT LOCK the table/row/record/whatever. The thing to do if you want it to work like this is add a flag to the table. When someone needs to...

run backups of the dbs. Detach the dbs, you can detach msdb, but might be just as easy to restore.

Uninstall SQL. If you get errors, delete the files under program...

Pronounce it however the person your're talking to does. Makes life simpler.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

From what I understand, once the mdf is created, it is Zeroed out to ensure the state of the file. This is what takes the time.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Have to test on your system and see. How many items? If it's not a large enough table, it will be scanned anyway.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

create procedure MySP

@var varchar(20) = null

as

if @var = null

Select * from news_items

else

Select * from news_items

where division = @var

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Good idea. We'll take this up.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

We have some apps that access SQL Server using JDBC. Use 3rd party drivers, Merant I think, not the MS driver. Works ok, only supports Standard Auth (by JDBC spec).

Steve...

I'd argue you have too many indexes and need to scale this back.

You could also horizontally parition the table into two. Even use a view to join them back and...