Viewing 15 posts - 6,721 through 6,735 (of 49,552 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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 22, 2015 at 6:11 am
What exactly did you do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 22, 2015 at 4:43 am
Just sp3. Service packs are cumulative.
No problems
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 22, 2015 at 1:21 am
Jeff Moden (1/21/2015)
GilaMonster (1/21/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 21, 2015 at 7:17 am
Viewing 15 posts - 6,721 through 6,735 (of 49,552 total)