Amazon.com sells SQL 2008 and 2005 Developer Editions DVD's

$50 USD for SQL 2008

What do you mean? It could be due to the Daylight Saving Time

I see this (It is 9:53am Eastern Daylight Time in Ontario, Canada)

I think I set my Timezone in...

I have always Copied (and deleted unnecessary stuff) too

If there's an easier way, it'll be cool to know.

Are you talking about TFS Database (or DataDude?) vs Red Gate?

Personally I like Red Gate tools better, period

I have used...

Google is a good friend

You're just reversing the direction, going from DT_NTEXT to DT_TEXT, and input vs output

Idea is the same

Converting DT_TEXT into DT_NTEXT[/url]

Hi SIDDARTH

Perhaps an example would help as well?

Did you try the OUTPUT clause?

I always thought SCOPE_IDENTITY only works for the last single record inserted

so if current ID is...

http://msdn.microsoft.com/en-us/library/ms159261.aspx

I am thinking of setting up IIS sites and resolve the http://reportsite on it

or setup your Domain Controller to forward/resolve REPORTURL to the SERVERNAME

My AdventureWorks2008.mdf is 184MB, don't think it's that easy to upload

You should still try to figure out why it was restored as empty

or try a different installer (or the non-installer...

Is it possible to Group By to have the automated subtotal/group footer for the subtotal?

If not

you can use the IIF(Description.value = "Subtotal",true_condition,false_condition) statement in the text field properties

Bold: Font ->...

If possible, I may even prefer to do it in the T-SQL at times

Calculated column in the Table, or Calculated field in the SSRS Dataset both would work

See forum best practice

http://extras.sqlservercentral.com/prettifier/prettifier.aspx

I would suggest start with Sample Data/Table scripts

I don't quite understand the question, and it also sounds like an assignment/homework? 😛

Oops, I meant to post the Best...

?? I never said I never edited my post

I also said I made an error on the INNER JOIN clause (replace WHERE with ON)

I edited the original post so that...

In your function

you can RETURN NULL if input is NULL, it's safer this way as well

Here is a sample

CREATE FUNCTION UppercaseFirstLetter

(@InputString VARCHAR (4000))

RETURNS VARCHAR(4000)

AS

BEGIN

IF @InputString IS NULL RETURN NULL

ELSE ...

Another Canadian, yeah!

1. Good article, informative, should make it clickable

http://benchmarkitconsulting.blogspot.com/2008/10/smart-reindexing-sql-server-2005-2008.html

2. should pretty up the code on HTML

http://extras.sqlservercentral.com/prettifier/prettifier.aspx

3. I think you should also mention ONLINE index vs OFFLINE index, and that...

Look into sp_MSForEachDB (hidden MS procedure)

sp_MSforeachdb 'if ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'') use ? EXEC sp_droprolemember N'db_datareader', N'Jack'

sp_MSforeachdb 'if ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'') use ? EXEC sp_addrolemember N'db_datawriter', N'Jack'

Otherwise you can...