Viewing 15 posts - 106 through 120 (of 286 total)
sqlvogel (12/22/2014)
No, a "record number" / surrogate key is not necessary in all cases. Adding such a column to every table offers no general advantage in terms of performance.
Are you...
December 22, 2014 at 1:38 pm
ScottPletcher (12/8/2014)
can I created a snapshot of the prod database on the same server and run DBCC CHECKDB on the Snapshot DB?
Yes. It's easy, just like it sounds: create...
December 8, 2014 at 5:41 pm
Eric M Russell (12/5/2014)
Jeff Moden (12/5/2014)
Ed Wagner (12/5/2014)
Eric M Russell (12/5/2014)
The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users to enter all...
December 5, 2014 at 3:03 pm
4x4krzy (12/5/2014)
Nothing gets checked before it gets pushed to prod.
That's the root cause of your issues, that's what you have to fix. It's not technical issue and should not be...
December 5, 2014 at 2:45 pm
Maybe a trigger that blocks the creation of indexes? If a trigger is the way to go, what kind of impact could that have?
What will stop someone with sufficient permissions...
December 5, 2014 at 1:52 pm
If you want to know in details how SQL Server is joining tables you have to learn 3 types of joins: Nested loops, merge and hash. You can start here:...
December 5, 2014 at 1:42 pm
http://lmgtfy.com/?q=sp_whoisactive+tempdb_allocations
The most confusing of these columns are those related to tempdb. Each of the columns reports a number of 8 KB pages. The [tempdb_allocations] column is collected directly from the...
November 21, 2014 at 5:42 pm
There is no way you can stop SQL Server from writing to the log when rebuilding indexes. Saying that you have 2 options:
1. Rebuild less. For example, increase threshold after...
November 5, 2014 at 1:02 pm
Eric M Russell (10/27/2014)
October 27, 2014 at 3:12 pm
Darryn_the_Tired (10/16/2014)
Devs have told me they cant change this and its my problem.
If they can change the application then they are simply lying.
October 16, 2014 at 2:22 pm
ScottPletcher (10/16/2014)
Alexander Suprun (10/16/2014)
ScottPletcher (10/16/2014)
Alexander Suprun (10/16/2014)
October 16, 2014 at 2:20 pm
Haven't seen that OP had found a solution already.
October 16, 2014 at 2:11 pm
ScottPletcher (10/16/2014)
Alexander Suprun (10/16/2014)
October 16, 2014 at 2:09 pm
I doubt that anyone will be able to help until you say what is the purpose of the partitioning and how this table is used.
October 16, 2014 at 1:59 pm
davidwarner (10/15/2014)
Hi, I have an SQL Server which is running a vendor DB so we can't touch the DB.
Even if it is a vendor DB you still can make some...
October 16, 2014 at 1:55 pm
Viewing 15 posts - 106 through 120 (of 286 total)