#table is only visible to the SESSION

##table is global temp. table, visible to all, until the last session/user disconnects I believe

So replace #table with ##table, you should be able to...

Check Books Online

Linked Server

OPENROWSET

I am about to move our tempdb soon as well (due to unexpected crazy growth that fills up C drive)

move tempdb code

USE [master]

GO

ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev,...

+1

I think DMVs are "cumulative" until you restart SQL Server, or reset it

e.g. for wait DMV

Reset by DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR);GO

The_SQL_DBA (12/19/2008)

---

looks like sql 7 doesn't support device backups..i tried time and again but its copying only to a single file. I believe i ll have to have a dedicated...

Is SQL Server smart enough to know if you put in 11:45 pm to 04:45 am, it goes into next day?

Your theory could work, Mon-Fri 2345-0445, if it works on...

I have on my computer

SSMS 2008 Client installed + SQL Server 2008

SSMS 2005 Client installed

I can use SSMS 2008 client to connect to SQL 2000/2005/2008 in my company no...

What's the reason behind your manager not wanting to use the builtin Report Manager?

It's easy to start with at least

check the installed log (forgot where it's installed, probably in C:\Program Files\Microsoft SQL Server)

and copy the errors here

Note, you installed 3.5 SP1 too? just 3.5 is not enough, you need...

It worked fine for me on SQL 2008

You have to remove the period and lower case 'sysfiles' (SYSFILES won't work for me)

exec sp_MSForEachDB 'Use ? SELECT name AS ''Name of...

This is my observation from the 2005 exams

Self study is the best way to attack, I find the courses not too useful

Grab some test exams (Pass4Sure, TestKing, ExamCollection)... google as...

Interesting....

I know SQL 2008 requires .Net 3.5 SP1

why is it asking for 2.5....

Maybe download the 2.5 installer yourself and install it first?

I know clustering will add $$$$$ compared to Database Mirroring for sure

but Clustering seems the de facto way for large Enterprise who needs 24/7 uptime, period

I personally like DB Mirroring...

NEWID is the quickest way I know too

Can look into TABLESAMPLE as well

http://msdn.microsoft.com/en-us/library/ms189108(SQL.90).aspx

SELECT FirstName, LastName

FROM Person.Contact

TABLESAMPLE (10 PERCENT) ;

You can use TABLESAMPLE to quickly return a sample from a...

clearly I have a long way to go points-wise, while I'm still young....