Viewing 15 posts - 13,156 through 13,170 (of 49,552 total)
That would be correct as part of a SELECT statement. CASE isn't a statement, it's an expression used within a query.
So
SELECT
CASE WHEN fmwa.GroupNbr<>'' THEN 'NO'
WHEN dind.DefaultIndicator='Y' THEN 'YES'
ELSE 'NO'
END AS...
May 15, 2013 at 7:35 am
Depending on the type of disaster, you may be able to take a tail-log backup (google or see BoL).
If you can, then your restore would be last full backup,...
May 15, 2013 at 4:25 am
You don't really optimise schemas, so not sure what you're asking. The Line Items table needs either normalisation or sensible column names, can't tell which.
As for the query, you can...
May 15, 2013 at 1:39 am
Draelith (5/15/2013)
Using this link, http://support.microsoft.com/kb/307487, method 1 looks like it used the alter db to shrink the tempdb.
Look closer. That has SQL started in minimal config, which means TempDB...
May 15, 2013 at 1:15 am
Don't think you can use alter database to set a lower size than current. Unless someone went and explicitly grew the database ALTER DATABASE TempDB ... to set the files...
May 15, 2013 at 1:01 am
sql-lover (5/14/2013)
HanShi (5/14/2013)
May 15, 2013 at 12:55 am
DO NOT shrink TempDB with DBCC ShrinkFile or DBCC ShrinkDatabase unless the instance (not the database) is running in single user mode, it is documented to be able to cause...
May 15, 2013 at 12:49 am
jasona.work (5/14/2013)
(testing shows that enabling compression on the table will also enable it on the clustered index)
The clustered index IS the table.
But, my question stands, will the Alter Index...
May 14, 2013 at 2:33 pm
About the only use is as part of a rolling upgrade, so install a second SQL instance (same version), configure mirroring, make sure everything works and the app redirects properly,...
May 14, 2013 at 2:24 pm
Yes. If the OS requests SQL to reduce it's memory usage, SQL will do so, down to the value of min server memory.
May 14, 2013 at 9:42 am
Since you have locked pages enabled, SQL is using the physical alloc API to allocate memory for the buffer pool, that shows up as AWE memory (nothing to do with...
May 14, 2013 at 9:27 am
Tools -> Options. Environment -> General
Your master database is not missing, if it was SQL wouldn't even start.
May 14, 2013 at 9:21 am
It's in the system database folder under databases, along with model, msdb and tempDB
May 14, 2013 at 8:52 am
Read up on Log Shipping. Not that many other options on SQL 2000.
p.s. please post SQL 2000 questions in the SQL 2000 forums. Thanks
May 14, 2013 at 8:37 am
It is possible to have the mirror a higher version, but as I said it's a stupid thing to do and iirc it takes extra work to even set up...
May 14, 2013 at 8:26 am
Viewing 15 posts - 13,156 through 13,170 (of 49,552 total)