Viewing 15 posts - 14,746 through 14,760 (of 49,552 total)
Because it allows for parameterisation of the dynamic SQL (which exec does not). That leads to better plan reuse and better security
January 17, 2013 at 7:21 am
Index on (IsDeleted, SubmitDate DESC) include (ProdName,Category,TotalStock,Price)
btw, that's a rather odd predicate on the date column...
January 17, 2013 at 6:39 am
mitzyturbo (1/17/2013)
We still have the 2000 instance of this db, is there anyway we can pinpoint the change at that level, identify and migrate the fix?
Oh yes, absolutely and very...
January 17, 2013 at 6:38 am
Also, since this is SQL 2008, have a read up on Grouping Sets. They allow a lot more flexibility than cube and rollup do.
January 17, 2013 at 5:06 am
Bhuvnesh (1/17/2013)
The specialist is a person who knows everything about something but nothing about anything else.
If you want to be insulting, kindly be so elsewhere.
January 17, 2013 at 5:03 am
Put the DB into single user mode and run CheckDB(<database name>, repair_rebuild)
January 17, 2013 at 5:02 am
You'd have to restore the primary filegroup backup, the the secondary, then all the log backups since the oldest of those 2 backups to bring the DB to a consistent...
January 17, 2013 at 5:01 am
Firstly, because temp tables are in tempDB, and unless you are in that database, sys.tables refers to your user database's tables, not TempDB.
Secondly, because the name in the system catalog...
January 17, 2013 at 3:45 am
mitzyturbo (1/17/2013)
Cheers Gilla, have read a few blogs and articles about it and it would appear that if all else fails, recreate the database and import the data back across.
That's...
January 17, 2013 at 3:35 am
prakash.kumar3669 (1/17/2013)
in other words covering queries in not an option i guess.
Why not?
January 17, 2013 at 3:19 am
If the DB was brought online and a new log file created, the old one is completely useless and cannot be used.
Correct your alter database statements (I guess you didn't...
January 17, 2013 at 3:19 am
If you attached just the data file and had SQL rebuild the log, that old log file is now useless.
January 17, 2013 at 3:04 am
This one's nasty.
Someone, at some time, made changes directly to the system tables in SQL 2000. SQL 2000 didn't check for that when it ran checkDB, so it went...
January 17, 2013 at 3:03 am
No such thing as a secondary index. Do you mean a secondary XML index?
January 17, 2013 at 2:40 am
Viewing 15 posts - 14,746 through 14,760 (of 49,552 total)