Viewing 15 posts - 1,246 through 1,260 (of 7,504 total)
please provide the query plan(s).
My guess is the index is being scanned, so the updlock may indeed block it all.
p.s. are you sure this is a SQL2012 instance ? The...
April 1, 2013 at 2:06 am
an index sonsists of two parts :
a keys section and an included-columns section.
Books online shows how many columns or bytes each can have.
http://msdn.microsoft.com/en-us/library/ms143432.aspx ( see "Columns per index key")
This ref...
March 28, 2013 at 8:57 am
Koen Verbeeck (3/28/2013)
Your signature gets bigger by the years 😉
not only my signature 😉
In general: my...
March 28, 2013 at 8:46 am
- Is sqlbrowser running ?
- are you specifying the port number in your connection data ? If yes: did you modify it ?
March 28, 2013 at 8:45 am
so far for naming conventions 😉
convering index as a concept means a query ( or part of it ) can be served directly by the index itself, without having the...
March 28, 2013 at 5:50 am
March 28, 2013 at 5:02 am
On top of the previous replies you may want to double check the need for this instance to enable ad hoc workload optimization.
( just to prevent cache spill ram for...
March 28, 2013 at 4:56 am
indeed.
( for both sqlserver instances please, RTM is already a couple of years old and there are many fixes implemented with the SPs )
You only need to apply the...
February 21, 2013 at 11:54 pm
fatinnadiah88 (2/21/2013)
Both of the servers shows this information:Edition: Enterprise Edition
Product version: 10.50.1600.1
Product level: RTM
You posted in a SQL 2005 forum !
Your server is SQL2008R2 !
btw the current service pack...
February 21, 2013 at 5:09 am
Can you post these properties of your two sqlserver instances ?
Select Serverproperty('Edition') as Edition
, Serverproperty('ProductVersion') as ProductVersion
,...
February 21, 2013 at 3:06 am
is the data for your computed column considered static ?
if yes, use an insert trigger that gets that data and puts is in a regular column.
if no,
How about...
February 20, 2013 at 12:44 am
I would double check:
1- network bandwith and consumption ( drastically enhanced with SQL2008 ! in case you still need an upgrade reason )
2- I/O subsystem performance
3- ram pressure
of...
February 20, 2013 at 12:41 am
and chances this shouldn't be a SQLFunction at all, but a regular stored procedure.
Keep in mind, if a function doesn't perform well, it will drag down the query using it...
February 5, 2013 at 1:39 am
Did you try this ?
SELECT distinct
vs.volume_mount_point
, vs.volume_id
, vs.logical_volume_name
...
January 29, 2013 at 6:58 am
Viewing 15 posts - 1,246 through 1,260 (of 7,504 total)