Viewing 15 posts - 6,826 through 6,840 (of 7,597 total)
opc.three (1/31/2013)
February 4, 2013 at 10:32 am
GilaMonster (2/1/2013)
jfogel (2/1/2013)
One last question. I read that when executing the enable RCS command that there can't be any other connections or transactions open in that database.
Correct
Then the article goes...
February 1, 2013 at 3:23 pm
Ed Wagner (2/1/2013)
Also, btw, turn on IFI unless for security reasons you can't. That will dramatically speed up data file growth on all databases, including system ones.
What is IFI?
Try...
February 1, 2013 at 1:20 pm
I suspect the dbo.sales should really be clustered by date. If so, and you fix that, the rest of the query won't hurt the performance that much one way...
February 1, 2013 at 1:14 pm
If you can do w/o the direct DupesCount, you can also use an EXISTS check:
SELECT
dm.*
FROM @DuplicateMembers dm
WHERE EXISTS (
SELECT 1
...
February 1, 2013 at 1:08 pm
I like the technique overall, but the concatenation will likely hurt performance: maybe only slightly, maybe a lot, depending on indexing. Thus, I suggest GROUPing and JOINing w/o any...
February 1, 2013 at 1:03 pm
For a 500GB db, those are modest amounts of space to be available/reserved.
I think trying to shrink that db would do far more harm than good.
If you have multiple data...
February 1, 2013 at 12:44 pm
You need to go thru the process of designing tables to store what you need, including a process called "normalization".
Under no circumstances should you attempt to store multiple values in...
February 1, 2013 at 11:04 am
Change all filegrowth to fixed amounts rather than %s. That is, change anything like "10%" to a fixed amount instead, such as "1MB".
If you plan to store packages in...
February 1, 2013 at 10:56 am
karthik.catchme (1/31/2013)
•If you combine the autogrow and autoshrink options, you might create unnecessary overhead. Make sure that the thresholds that trigger the grow...
January 31, 2013 at 4:36 pm
ben.brugman (1/31/2013)
ScottPletcher (1/29/2013)
You may or may not need partitioning.But you absolutely need to determine the proper clustered index for the table.
I totally agree that a clustered index will help performance...
January 31, 2013 at 9:42 am
FYI, in case you want it, here's the query I use to get an overview of tables, indexes and their sizes:
SELECT
SCHEMA_NAME(o.schema_id) AS Schema_Name,
...
January 30, 2013 at 2:36 pm
vlad-548036 (1/30/2013)
declare @howMany int=3
insert top (@howMany)
can be used to force insertion...
January 30, 2013 at 2:29 pm
AndrewSQLDBA (1/29/2013)
I was in a discussion with a DB2 developer ...
He was trying to convince me that char is better performing than varchar
Andrew SQLDBA
First, let's be grateful he's a developer,...
January 30, 2013 at 10:16 am
Yes, shrinking log file routinely or unnecessarily is bad.
But A log shrink after an unusually extreme amount of activity would not be.
January 30, 2013 at 10:07 am
Viewing 15 posts - 6,826 through 6,840 (of 7,597 total)