Syed Jahanzaib Bin hassan (6/30/2011)

---

DBCC SHRINKDATABASE

Visit this link

http://support.microsoft.com/kb/307487%5B/quote%5D

don't listen to him ^

What Mr. Fritchey suggests is best if your problem is that you are running out of...

insert into [good_table]

(col1, col2, col3)

select

colA,

colB,

cast(left([ColC], 2) + '/' + SUBSTRING([ColC], 2, 2) + '/' + RIGHT([ColC], 4) as datetime)

FROM [dumb_table]

Something like that

SELECT name,recovery_model_desc

FROM sys.databases

That will tell you the recovery model for each database.

Grant Fritchey (6/29/2011)

---

calvo (6/29/2011)

---

^^

Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that...

If you post the actual query plan please, experts will be able to help in a more expeditious manner.

^^

Doesn't matter if it is standard, enterprise, or express, it's the same version number and that's all that matters. Now, assuming...

lawlz

with CTE as

(

select name,nameid

from #names

)

SELECT

name,

offidlist = STUFF((

SELECT

...

Rank1_nj (6/28/2011)

---

Am I Replacing the IF Statement where it says

IF @RandomCol = 'YES'

or am I relacing the @RandomCol Varaible's SET select statement?

because I tried replacing it with...

d'oh!

How long have you waited after the screen...

Since the @randomCol declared variable is never used and you're only performing an action if a user's field = 'yes',

instead of:

declare @randomCol varchar(100)

set @randomCol =

(Select RandomCol

from TableA

where...

DDL scripts, sample data, and expected output would be helpful.

Daniel Bowlin (6/24/2011)

---

A kind of a sideways way to do this would be to add a column to the left of your money column and just put a $ in...

I think the most important question to answer when trying to decide HA options is, what is the business requirement?

Is there an acceptable amount of downtime? Does the secondary server...

Oh man!

Riggleman (Nationals) just up and quits after a 1-0 win against the Mariners.

He said he did it on principal, but even if he's right about Rizzo not wanting to...