Viewing 15 posts - 6,721 through 6,735 (of 49,571 total)
Parameterise your queries!
Don't try to blacklist, it doesn't work. Write properly parameterised queries, don't concatenate user input into a string and execute it.
January 22, 2015 at 6:54 am
Ed Wagner (1/22/2015)
There's an option in the restore command to verify the backups (RESTORE VERIFYONLY), but it only verifies the backup file itself.
It only validates the header of...
January 22, 2015 at 6:12 am
jacksonandrew321 (1/22/2015)
Ed Wagner (1/22/2015)
From the OP, I can only assume that backups are being taken but not tested, so how do...
January 22, 2015 at 6:11 am
What exactly did you do?
January 22, 2015 at 5:23 am
Back up a sec...
Attach is what you do to database files (the mdf, ldf). Is that what you have, copies of the database files?
If you have a backup, then you...
January 22, 2015 at 5:22 am
The instance collation is just the default when creating databases. If you explicitly define a collation when creating a database (or tables), the instance default will be ignored.
January 22, 2015 at 5:10 am
Actually, that's easy to teach.
"Call the DBA."
Repairing a SQL DB is not something that an end user can do at all, as it requires sysadmin access and a lot of...
January 22, 2015 at 4:43 am
Just sp3. Service packs are cumulative.
No problems
January 22, 2015 at 4:39 am
You've been asked this as part of your job? If so, ask your boss/manager if they can allocate you time to prep such a course. Rough guideline there is 8...
January 22, 2015 at 2:46 am
A stored procedure has a single plan, parameters will not cause a procedure to have multiple plans.
Write queries and procedures in the simplest way, only if testing shows a problem...
January 22, 2015 at 1:27 am
Do you have a license for SQL 2008 R2? If not, buying one would have to be the first step. That said, if you're upgrading at this point in time,...
January 22, 2015 at 1:21 am
Jeff Moden (1/21/2015)
GilaMonster (1/21/2015)
January 21, 2015 at 8:21 am
Tara-1044200 (1/21/2015)
I will be backing up from 2008 R2 and restore on 2005 Ent.
No, you won't, because SQL databases cannot be downgraded. If you have a SQL 2008 R2 database...
January 21, 2015 at 8:17 am
Bulk Inserts don't fire triggers. Nothing to do with the trigger code (which, from the looks of things needs a lot of work to optimise it). The Bulk Insert itself...
January 21, 2015 at 7:58 am
Separating the lobs into a different table has good and valid reasons for doing. Separating them onto a separate filegroup (TEXTIMAGE ON ... and recreating the table) however is not...
January 21, 2015 at 7:17 am
Viewing 15 posts - 6,721 through 6,735 (of 49,571 total)