Viewing 15 posts - 23,821 through 23,835 (of 49,552 total)
To answer the question that was implied, not asked, there is no index that can help a SELECT * FROM <table> query. Indexes are there to support where clause predicates...
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
August 29, 2011 at 12:59 pm
mtillman-921105 (8/29/2011)
But communism is not seriously considered a real option anymore.
Come down and tell some people in government here that. It would come as a revelation to them.
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
August 29, 2011 at 12:52 pm
And right on cue, a PM that's leaning towards harassment. <sigh>
Why do some people think that just because I've answered a couple of their questions that I'm their BFF?
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
August 29, 2011 at 12:50 pm
In what context? SSIS packages?
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
August 29, 2011 at 12:33 pm
WayneS (8/29/2011)
Just read this: http://ittybiz.com/death-threats-online/. Appalling.
Unbelievable. What is it, that they feel threatened by someone else's success?
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
August 29, 2011 at 11:22 am
Create an index with business_date as the leading column, and stop using select *
The nonclustered index that you had was useless because business_date was not the leading column, and that...
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
August 29, 2011 at 10:20 am
krowley (8/29/2011)
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
August 29, 2011 at 8:36 am
Err, there isn't any physical relationship between tables.
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
August 29, 2011 at 8:32 am
Please give me the actual index definition. I can't match a made-up one to the execution plan (that has the real table and column names in it).
In fact, please post...
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
August 29, 2011 at 7:14 am
If you're going to enable AWE, that has to be enabled. If you do enable it, you MUST set a max server memory that leaves enough space for the OS...
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
August 29, 2011 at 5:31 am
No good reason. It's just forcing SQL to recreate them when it needs them.
p.s. Maybe also change the job not to use deprecated system views while you're editing?
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
August 29, 2011 at 5:16 am
If ColX is the leading column of that index, won't help at all. If your index is on (colX, Coly) (in that order) that query should not scan, it's perfectly...
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
August 29, 2011 at 5:07 am
ananda.murugesan (8/29/2011)
Ok, I should change and setting max memory in SQLSERVER Instance.If server 4 GB RAM, how much I should allocated for max memory?
Depends what else is running on the...
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
August 29, 2011 at 5:04 am
If you want to reduce memory usage, you must set max memory. By leaving it at default you're telling SQL it can use as much memory as it wants with...
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
August 29, 2011 at 4:44 am
Brandie Tarvin (8/29/2011)
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
August 29, 2011 at 4:39 am
Viewing 15 posts - 23,821 through 23,835 (of 49,552 total)