Groups
Sign in
Groups
microsoft.public.sqlserver.relationalserver.performance
Conversations
About
Send feedback
Help
info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Learn more
microsoft.public.sqlserver.relationalserver.performance
Contact owners and managers
1–30 of 203
Mark all as read
Report group
0 selected
disc...@iphone.bell.com
4/19/20
iPhone SUPER 80% discounts
*** iPhone SUPER-SPECIAL-DISCOUNT 80% OFF --- UNBEATABLE SUPER-PRICES !!! *** Save LOTS OF CASH on a
unread,
iPhone SUPER 80% discounts
*** iPhone SUPER-SPECIAL-DISCOUNT 80% OFF --- UNBEATABLE SUPER-PRICES !!! *** Save LOTS OF CASH on a
4/19/20
kill...@coronavirus.com
4/18/20
coronavirus COVID-19
coronavirus COVID-19 http://www.grex.org/~henced/coronavirus.html
unread,
coronavirus COVID-19
coronavirus COVID-19 http://www.grex.org/~henced/coronavirus.html
4/18/20
Ma...@getfucked.com
11/10/17
Uploads - What is wrong with Easynews
Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no
unread,
Uploads - What is wrong with Easynews
Looking for Star Trek Discovery season 1 Episodes 6 onwards in english. Why does it seem there are no
11/10/17
Nicholas Randall Forystek
7/12/16
............................................................
...........................................................
unread,
............................................................
...........................................................
7/12/16
mirthcyy
,
Erland Sommarskog
2
6/7/11
werid query performance issue
mirthcyy (mirt...@gmail.com) writes: > We are using sql server 2005 enterprise 64 bit in our
unread,
werid query performance issue
mirthcyy (mirt...@gmail.com) writes: > We are using sql server 2005 enterprise 64 bit in our
6/7/11
GC
, …
Gene Wirchenko
5
5/31/11
Enforcing unique constraint with trigger causes deadlock - sql server sp1
On Tue, 31 May 2011 23:37:23 +0200, Erland Sommarskog <esq...@sommarskog.se> wrote: >Gene
unread,
Enforcing unique constraint with trigger causes deadlock - sql server sp1
On Tue, 31 May 2011 23:37:23 +0200, Erland Sommarskog <esq...@sommarskog.se> wrote: >Gene
5/31/11
ghdfans2010
6/7/10
Red Lust——ghd new limited edition color collection
The gorgeous new limited edition colour collection from GHD is on the market ! This collection is
unread,
Red Lust——ghd new limited edition color collection
The gorgeous new limited edition colour collection from GHD is on the market ! This collection is
6/7/10
nn...@microsoft.com
5/28/10
Final Reminder - Microsoft Responds to the Evolution of Community
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing
unread,
Final Reminder - Microsoft Responds to the Evolution of Community
What is Happening? This message is to inform you that Microsoft will soon begin discontinuing
5/28/10
OceanDeep via SQLMonster.com
,
Erland Sommarskog
2
5/27/10
index seek with lookup vs index seek with include
OceanDeep via SQLMonster.com (u46587@uwe) writes: > I have a table tbltest with 10 fields and say
unread,
index seek with lookup vs index seek with include
OceanDeep via SQLMonster.com (u46587@uwe) writes: > I have a table tbltest with 10 fields and say
5/27/10
OceanDeep via SQLMonster.com
,
Erland Sommarskog
2
5/26/10
SQL 2008 with more cpu core
OceanDeep via SQLMonster.com (u46587@uwe) writes: > We are using SQL 2008 64 bit sp 1 std on
unread,
SQL 2008 with more cpu core
OceanDeep via SQLMonster.com (u46587@uwe) writes: > We are using SQL 2008 64 bit sp 1 std on
5/26/10
OceanDeep via SQLMonster.com
,
Erland Sommarskog
6
5/18/10
Ram size vs speed
OceanDeep via SQLMonster.com (u46587@uwe) writes: > Thank for the quick response. I want to get
unread,
Ram size vs speed
OceanDeep via SQLMonster.com (u46587@uwe) writes: > Thank for the quick response. I want to get
5/18/10
Mitch
, …
Shin Zhang [MSFT]
8
4/30/10
Logical Reads
I would not suprise if you see a hash join based plan changed to nested loop join based plan. That
unread,
Logical Reads
I would not suprise if you see a hash join based plan changed to nested loop join based plan. That
4/30/10
Tom Dacon
,
Erland Sommarskog
5
4/29/10
Job runs slow every seven days...why?
"Erland Sommarskog" <esq...@sommarskog.se> wrote in message news:
unread,
Job runs slow every seven days...why?
"Erland Sommarskog" <esq...@sommarskog.se> wrote in message news:
4/29/10
Brian Brian
,
Erland Sommarskog
2
2/10/10
set nocount on and ad hoc query
Brian Brian (Brian...@discussions.microsoft.com) writes: > We are running an application with a
unread,
set nocount on and ad hoc query
Brian Brian (Brian...@discussions.microsoft.com) writes: > We are running an application with a
2/10/10
Iter
, …
Uri Dimant
5
12/15/09
AVG DISK QUEUE LENGTH is very high when run sys.dm_db_index_physic
Ah I see, I hoped you specified a database/table/index scope when you ran this dmv because it is
unread,
AVG DISK QUEUE LENGTH is very high when run sys.dm_db_index_physic
Ah I see, I hoped you specified a database/table/index scope when you ran this dmv because it is
12/15/09
Hoardling1 via SQLMonster.com
, …
Will Alber
5
12/4/09
Truncating a lot of data does it cause extreme memory usage.
Making the copy processes less parallel will definitely help with memory consumption - although if
unread,
Truncating a lot of data does it cause extreme memory usage.
Making the copy processes less parallel will definitely help with memory consumption - although if
12/4/09
Heinrich Moser
, …
Balaji
4
11/24/09
SUM/GROUP performance and the Primary Key
Thanks to both of you! Greetings, Heinzi "Balaji" <tbalaj...@gmail.com> writes:
unread,
SUM/GROUP performance and the Primary Key
Thanks to both of you! Greetings, Heinzi "Balaji" <tbalaj...@gmail.com> writes:
11/24/09
Zaur Bahramov
,
Erland Sommarskog
2
11/7/09
Low performance on SQL Server 2008 Std 64 bit
Zaur Bahramov (zbakh...@msn.com) writes: > I have installed a Windows Server 2008 64bit with SQL
unread,
Low performance on SQL Server 2008 Std 64 bit
Zaur Bahramov (zbakh...@msn.com) writes: > I have installed a Windows Server 2008 64bit with SQL
11/7/09
Ganesh Subbiah
,
Jeremy A. Holovacs
2
10/12/09
The query execution taking too long
please correct your punctuation, Is it 8000000 or 800000 records? 31140516 records? 3114516? It makes
unread,
The query execution taking too long
please correct your punctuation, Is it 8000000 or 800000 records? 31140516 records? 3114516? It makes
10/12/09
Peter
, …
Erland Sommarskog
5
10/12/09
int vs varchar recordset retrieval performance differences
Peter (Pe...@discussions.microsoft.com) writes: > We are creating a new SS 2005 database from 3
unread,
int vs varchar recordset retrieval performance differences
Peter (Pe...@discussions.microsoft.com) writes: > We are creating a new SS 2005 database from 3
10/12/09
Pedja
, …
Ruben Garrigos
3
9/27/09
Did it do partition elimination?
Hi Pedja, Apart from the useful execution plans that Erland requested it will be nice to have some
unread,
Did it do partition elimination?
Hi Pedja, Apart from the useful execution plans that Erland requested it will be nice to have some
9/27/09
Mark Price
, …
Ruben Garrigos
4
8/31/09
Table Join Order
Hi Mark, The optimizer will almost always get a good join order. When the number of joined tables is
unread,
Table Join Order
Hi Mark, The optimizer will almost always get a good join order. When the number of joined tables is
8/31/09
GaryBMemphis
,
Erland Sommarskog
8
8/23/09
Performance Problem on New Server
GaryBMemphis via SQLMonster.com (u54189@uwe) writes: > On July 5th, a routine that has been
unread,
Performance Problem on New Server
GaryBMemphis via SQLMonster.com (u54189@uwe) writes: > On July 5th, a routine that has been
8/23/09
Hoardling1 via SQLMonster.com
, …
Uri Dimant
5
8/21/09
SQL Profiler and troubleshooting.
Thank you, I copied Glenn Berry information and am reading through it. Theres a bit, but I think it
unread,
SQL Profiler and troubleshooting.
Thank you, I copied Glenn Berry information and am reading through it. Theres a bit, but I think it
8/21/09
Shamshad Ali
, …
Andrew J. Kelly
10
8/13/09
Hardware based database partitioning for Optimal Performance and Reliability???
Don't get us wrong we are not trying to avoid answering your questions. Both Erland and myself
unread,
Hardware based database partitioning for Optimal Performance and Reliability???
Don't get us wrong we are not trying to avoid answering your questions. Both Erland and myself
8/13/09
pardhiveswar
,
RickNZ
2
8/3/09
sql issue urgent pls
The scope of the table variable doesn't extend into the dynamic SQL. Your query should include
unread,
sql issue urgent pls
The scope of the table variable doesn't extend into the dynamic SQL. Your query should include
8/3/09
kuidokylm
,
Erland Sommarskog
3
7/22/09
Variable in SELECT expression causes query degradation
kuidokylm (u2904@uwe) writes: > How to avoid this query performance degradation > > this
unread,
Variable in SELECT expression causes query degradation
kuidokylm (u2904@uwe) writes: > How to avoid this query performance degradation > > this
7/22/09
Jay Douglas
, …
Erland Sommarskog
6
7/16/09
Deadlock (1205) error, please help!
The fix was adjusting a query earlier in the transaction that had an inner join that referenced a
unread,
Deadlock (1205) error, please help!
The fix was adjusting a query earlier in the transaction that had an inner join that referenced a
7/16/09
Heinrich Moser
, …
WOLO Laurent
8
6/14/09
How to make SQL Server choose a smarter query plan?
The order by is a very cost operation, avoid it if you can "Heinrich Moser" <usenet@
unread,
How to make SQL Server choose a smarter query plan?
The order by is a very cost operation, avoid it if you can "Heinrich Moser" <usenet@
6/14/09
greggo
, …
WOLO Laurent
6
6/14/09
Performance Problem
Do you have any indexes for description and tags ? "greggo" <u51702@uwe> a écrit dans
unread,
Performance Problem
Do you have any indexes for description and tags ? "greggo" <u51702@uwe> a écrit dans
6/14/09