Easy basic programming RTRIM question.

Yes. Transactional Replication would be the best option.

gary.jenkinson01 (6/14/2010)

---

Hi guys, ok here is what I have so far.

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Administrator',

@recipients = 'gary.jenkinson01@rotherham.gov.uk',

@subject = 'Fragmentation...

michael.kaufmann (6/10/2010)

---

Just verified the finding in SQL Server 2005:

- With MODEL being in READ_ONLY mode, when creating a database using the wizard, it is created read_only. No more changes are...

I don't see any trick here but the only thing that returns rows is cause of " GO " statement else it would return error at create constraint statement, since...

Excellent info and tool Stanley. Tried now and it took less that 25 minutes to get info for 162 servers.

Good thing is this tool generates the kind info which...

Another way here:

DECLARE @key VARCHAR(100)

DECLARE @PortNumber VARCHAR(20)

SET @key = 'SOFTWARE\MICROSOFT'

IF CHARINDEX('\',@@SERVERNAME,0) <>0

BEGIN

SET @key = @key + '\Microsoft SQL Server\' + @@SERVICENAME

END

ELSE

BEGIN

...

Good and easy but most imp. DBA interview question. In most interviews I was always asked pro's and con's of Simple, full and Bulk-logged recovery mode databases.

Instead of Person.sp_ReturnSomething, create proc with dbo prefix and it returns 5.

I got it wrong as I don't have Adventureworks DB. But, with testing it and getting right would...

Good article and very well explained. But, still had a question.

How many people had actually used it ? I had not come across anyone in real time ,...

Got it wrong. Even can't find correct answer in Wikipedia.

http://en.wikipedia.org/wiki/Defensive_programming

and some examples: http://www.tushar-mehta.com/excel/vba/vba-defensive_programming.htm

Is there any white papers released for Data Center is a new edition. Please let us know.

I would like to see them as we had a new project coming...

tosscrosby (4/22/2010)

---

I agree, a very poor question indeed. At a minimum, it should have given the minimum version of SQL to run on. I only have 2000 and...

All answers except last one READ-Only is wrong. You can set Model read only in both 2005 and 2008.

USE [master]

GO

ALTER DATABASE [model] SET READ_ONLY WITH NO_WAIT

GO

ALTER DATABASE [model]...

Good reading. But, how about the performance on high availability high volume application ? Had you tested it and got results, then please post it. Would be...