Forum Replies Created
Viewing 15 posts - 211 through 225 (of 286 total)
-
RE: Index Fragmentation and Performance
pooyan_pdm (8/8/2012)
you should specify the fill-factor for an index based on the number of inserts,Wrong
updates on the index key(s)
Not only updates on the index key can cause fragmentation
the...
-
RE: index size for sql server 2008
wendy elizabeth (8/3/2012)
The only option I can see is to increase the size of the field to varchar(886) instead of varchar(900). Are there any other options I would have?Drop index2
Why...
-
RE: Sum value for same sub_id with different id
select SUM(a.t),pfrom @table3 a
where exists
(
select n
from @table3 t
where (p = 1 or p =...
-
RE: Improve performace of a simple query
Sean Lange (6/5/2012)
Alexander Suprun (6/5/2012)
Sean Lange (6/5/2012)
Tripz (6/5/2012)
my UserPreferences i.e bbbb has comma separated region ids and category ids, that is the reason to use fn_split functionI understand the...
-
RE: Improve performace of a simple query
Sean Lange (6/5/2012)
Tripz (6/5/2012)
my UserPreferences i.e bbbb has comma separated region ids and category ids, that is the reason to use fn_split functionI understand the point of the function,...
-
RE: Improve performace of a simple query
Tripz (6/4/2012)
HiThank you
Here is the DDL of the functions
-------=========================================================
ALTER FUNCTION [dbo].[fn_getUserCategoryList](@userID int)
RETURNS VARCHAR(MAX)
AS
BEGIN
DECLARE @list nvarchar(64)
SELECT @list = category FROM t_UserPreferences WHERE userID = @userID
DECLARE @listStr VARCHAR(MAX)
SELECT@listStr = COALESCE(@listStr+',...
-
RE: The Real World: Fragmented Disk and High PAGEIOLATCH Waits
jswong05 (4/23/2012)
Just to clarify there are differnt operating systems:http://www.whylinuxisbetter.net/items/defragment/index.php?lang=
1. Your link is not related to the topic discussed at all.
2. It doesn't explain what will happen if there is no...
-
RE: The Real World: Fragmented Disk and High PAGEIOLATCH Waits
I just wonder, is 400 fragments for 300GB database file is a really-really bad thing which affects performance? It means that an average fragment size is around 755Mb. Isn't it...
-
RE: Data tuning in SQL 2005
Quick tool for you is to hire a professional who can help you identify performance problems and provide a solution.
-
RE: Long running query on only one server
How do you expect someone to explain it to you if we don't know what exactly have you changed and how the execution plan looks now? In general, by changing...
-
RE: Long running query on only one server
SQLJocky,
I know exactly what is wrong with your query. We had the similar issue before.
If you look at the plan you'll see a nested loops without a JOIN predicate. In...
-
RE: WHERE clause
Gianluca Sartori (3/9/2012)
Sure it works, but it won't use indexes.I would recommend using dynamic SQL in this case.
You can look it up in Erland's article.
It may use indexes to...
-
RE: BETWEEN
Lynn Pettis (3/8/2012)
Alexander Suprun (3/8/2012)
There is no correct answer to the question, because the query may return either 6 or None records.Here is my result:...
Looks like you may have a...
-
RE: BETWEEN
There is no correct answer to the question, because the query may return either 6 or None records.
Here is my result:
-
RE: Order by While inserting
ScottPletcher (2/16/2012)
When did SQL Server start doing these "auto sorts" for clus indexes?Common sense tells me it was like this since the day clustered indexes were implemented in SQL Server.
Viewing 15 posts - 211 through 225 (of 286 total)