ramadesai108 (9/23/2008)

---

Hello All,

Desperately need your help in deciding whether to install SQL Server 2008 on Windows 2008 or Windows 2003. Does any one know if there...

If restoring on an existing database use REPLACE and RESTRICTED_USER in restore command.

or kill all processes using this database at the time of restore.

HKwai (9/16/2008)

---

There are many articles says that small table you probably don't need any indexes because the exeuction plan will do better doing a full table scan than doing the...

i didn't get any error.

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days varchar(3),

@hr VARCHAR(50),

...

Great article. I had an index move task in last week of this month and definitely try your scripts on testing env. and let you know results, how it...

Change in collation level even at operating system can change the sort order. I had been through this when I moved 2000 database (Latin1_general_AS_CI) to 2005 server (Latin1_General_BIN).

Try

((lease_new_amount - lease_original_amount ) / 30.5)

you have 7 opening and 6 closings in it.

first of all, don't shrink it unless you have to because space needed on the drive by something else. Tempdb has grown to this size because it needed to at...

My tempdb database property shows size as 16.6 GB and space available 99%. when I look at shrinkfile window datafile show 16.6 Gb size but in shrinkfile size to...

Uuhhh.......Good read but I admit I am bad at understanding complicated SSIS packages.

Good article. But, OpsMgr is not as accurate and trust worthy as it has to be. I implemented it couple of weeks back and even though my dev...

Good reply.

Googled it and found this. Though not a good way to do. As I have more than 270 package and I can't sit opening all packages. Is there...

Anyone here?

Just to add. Error is in this line.

SET @strColumnList = left(@strColumnList,len(@strColumnList)-1).

I tried differently but could not get the result I wanted. like.

SET @strColumnList = LEFT(@strColumnList, CHARINDEX(' ', @strColumnList) -...

HI,

When I execute script1 from the article I get this error:

Server: Msg 536, Level 16, State 3, Line 210

Invalid length parameter passed to the substring function.

My database default collation is...