Your question is quite unclear.

1. What do you mean by pausing?

2. Read from this section from BOL:

If database mirroring is removed completely, the mirror database is in...

Nice question and learnt something!

It depends! And there is no standard formula as per my knowledge. But I would prefer to import access table in a dummy sql table with varchar type of Age...

daveriya (9/19/2011)

nobody understand my prob here,i past my query also, the thing is in my query i need to calculate WAL, that is only value i need to display ,i...

What I did in the end was to enable the Super Admin account in Windows 7 which by passes all UAC, I then re-installed SSRS and now it seems to...

I have performed a native install of SSRS 2008 R2 on Win7 Home edition. Now when I have try to access the Report Manager I get an error of :

User...

Indeed, it's an interesting thing to learn. Thanks.

Very nice question Srikant 🙂

huh!!!!

DECLARE @STR VARCHAR(255) =' rajneeh

kumar

is

working in technext'

SET @STR = ' ' + @STR

SET @STR = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@str, ' a', '...

Cool 🙂

I am using currently this one. Though with loop but It's not slower for me:

DECLARE @InputString as VARCHAR(1000) ='chocolate dipped strawberries mini cake '

DECLARE @index ...

You should use PIVOT statement.

Good Question!

Char is a function also, returning ascii character.

Therefore, select Char(100) returns you 'd'

Hmmm... You can try these lines to see the difference:

select CONVERT(char, 'This is a SQL Server Central Forum')

select CONVERT(char(1), 'This is a SQL Server Central Forum')

select CONVERT(char(100), 'This is a...