Viewing 15 posts - 1,006 through 1,020 (of 1,219 total)
SQL Server MVP Hugo Kornelis has written a couple of blog posts about bin packing, see http://sqlblog.com/blogs/hugo_kornelis/archive/tags/Bin+Packing/default.aspx
July 30, 2013 at 3:36 pm
If you want a fix table, the only option would be to import the lines as they are to crack them later. Or size the table for the maximum possible...
July 30, 2013 at 3:33 pm
DesmoShane (7/30/2013)
E.G. select top 1 no problem at all , select * from is going to take a while and have heavy usage of tempdb .
Maybe. All depending on the...
July 30, 2013 at 3:30 pm
DesmoShane (7/30/2013)
July 30, 2013 at 3:10 pm
My biggest concern is the use of SELECT *. This is a bad thing to put in a view definition (or in application code in general).
Else, there is not...
July 30, 2013 at 2:09 am
Kalyan Boddupalli (7/30/2013)
1. Make sure nolocks are maintained on the tables from where the data is getting selected
Do you mean that the NOLOCK hint should be used? Have ye no...
July 30, 2013 at 2:05 am
No. Say that a procedure consists of four statements, A, B, C and D. Only statement C refers to the table X. Because statistics on X are updated, the plan...
July 30, 2013 at 1:35 am
For a crash-course in how to shred XML, you can read here: http://www.sommarskog.se/arrays-in-sql-2005.html#XML.
July 30, 2013 at 1:26 am
It's a little tricky to work with context_info. See here for how for examples: http://www.sommarskog.se/grantperm.html#context_info. (That's a section in a longer article, and you only need to read down to...
July 30, 2013 at 1:24 am
T.Ashish (2013-07-29)
A view without any Index, but bound with schema.Does it gives any performance difference.
For a view, no. But for a scalar user-defined function WITH SCHEMABINDING can be important.
July 30, 2013 at 1:17 am
It could be the correct action to change the fillfactor to 70 or 80 for a specific table, if you have conducted careful analysis that your biggest problem is page...
July 29, 2013 at 4:14 pm
From what you say, it does not seem that the collation matters, although collation mismatches certainly can cause performance issues. (But mostly they cause error messages.)
Ratherm I would think that...
July 29, 2013 at 4:09 pm
decimal(10,0) and datetime are not really the same thing...
The error message is clear: it says that you need to add a computed and persisted column to the base table which...
July 29, 2013 at 3:48 pm
AWE is definitely enabled.
Adding the startup option -g512 should not be a problem, and I recommend that you try that. This is a quite common thing to do.
When this problem...
July 29, 2013 at 11:33 am
The log you posted, disagrees with the output you posted from "SELECT @@version":
Microsoft SQL Server 2005 - 9.00.5069.00 (Intel X86) Aug 22 2012 16:01:52 Copyright (c) 1988-2005 Microsoft Corporation Standard...
July 29, 2013 at 10:24 am
Viewing 15 posts - 1,006 through 1,020 (of 1,219 total)