steveb (12/9/2008)

---

CURRENT_TIMESTAMP is ANSI code

GETDATE is...

Jerry Hung (12/9/2008)

---

Not for a long time I hope, GETDATE() and GETUTCDATE() are too widely used

I...

Both getdate() and CURRENT_TIMESTAMP returns same value. So, why two functions for same result?

Can some one describe diff. between both function?

No same job can run concurrently in any version. When a job is running and not completed you cannot run it again in between period unless it gets completed.

Check...

Good collection of freeware. Will definitely try couple of them in Administration and Monitoring.

Thanks for all the info.

xp_cmdshell is by default disabled in SQL server 2005 unlike SQL Server 2000. You have to enable it by Sp_configure or by configuration manager.

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC...

Got answer right by fluke. Wasn't sure if I should select his option or not. Though I thought this should be in.

-- This option may not be specified...

CREATE INDEX NotAllowed

ON Dest (Value)

WITH(IGNORE_DUP_KEY = ON);

go

Msg 1916, Level 16, State 4, Line 1

CREATE INDEX options nonunique and ignore_dup_key are mutually exclusive.

ignore_dup_key should come...

http://blogs.msdn.com/craigfr/archive/2006/10/25/the-parallelism-operator-aka-exchange.aspx

http://blogs.msdn.com/craigfr/archive/2006/11/16/parallel-hash-join.aspx

And here is a good article about parallelism in sqlservercentral.

http://www.sqlservercentral.com/articles/Configuring/managingmaxdegreeofparallelism/1029/

Also, see the discussion on this article.

hydbadrose (11/3/2008)

---

Should be the autogrow option enabled or disabled? Currently, the db I am dealing with is 75 GB and the autogrow option is enabled with 10% restricted growth. Should...

After taking the backup of transaction log, all transactions are backed up and log file get empty but size would not reduce.

That you have to do using this command.

use database

go

DBCC...

Either use third party tool like SQL diagnostic manager or else you can run profiler for a week on those particular databases and collect data into a table. If...

Check linked server properties and check security context.

Most probably this would be an issue and if you have access on both server then select this option - Be made using...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=108800&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=292689&SiteID=1

I think disabling VIA is the only and easiest option.

No. Server reboot is not needed. But while installing SSIS, process will stop and restart MSSQLSERVICE.