First of all Books On line contains quite a lot of Tutorials and sample packages.

The next stop I would suggest is http://www.sqlis.com

Lot's of articles and samples about SSIS.

The latest number is 209, see here for all the names etc.

https://mvp.support.microsoft.com/communities/mvp.aspx?product=1&competency=SQL

Sorry, but UPDATETEXT is the correct answer, depracated or not.

Update .Write doesn't work for text columns.

Obviously the answer will always depend on the type of query you're running.

But if you're more interested in the theoretical scalability you can check http://www.tpc.org/ for benchmarks.

There are several options on how to do this. You might want to check out this article: http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

or this one:

http://vadivel.blogspot.com/2007/04/find-missing-numbers-gaps-within-table.html

Sounds like a DNS problem to me. Check which DNS server is configures, which default gateway etc.

You can query the msdb database for the last backup of a database.

Something like this:

select top 1 name+'.bak' from msdb..backupset

where type = 'D' and database_name = MyDb

Order By backup_set_id

Type 'D'...

Why don't you just query the DMV sys.dm_db_index_usage_stats. It will show you which idexes have been used and how (Seek vs. scan)and even when it was used the last time.

Only...

The only option to do this is to create either a view, give your users read permission on the view and deny read permission on the table.

If you want to...

No problem, you're welcome

Ola is right.

I had the same issue on several machines and the hotfix solved the problem.

If you search around you will find several scripts which will KILL all ser connections to a database. Personally I prefer setting the database in single user mode and rollback...

Not sure if I understand you're question.

The stored procedure I provided will write the trace to one or more files. Other than that...

From last couple of days our production DB is running at 100% CPU usage, after going through profiler we are able to trace using Audit Login option that every fraction...

Creating a snapshot of 12 million rows can take quite long and like in your case can result in a timeout. You can change the profile of the snapshot agent...