Hi all

Response from the MS SQL Server group...im still not happy with it [:-D]

> Its a bug, you guys wont admit it! 🙂

No its a not bug, you won't admit...

Hi

9Gb? cripes. The key issues with differentials is that its based on whole extents, rather than individual page changes, even if a single page in the 64k extent has...

Email the base table creates and I will try on my hyperthreaded machine..

also...

select A.*, B.bid

from aaaaa as A left outer join bbbbb as B

on A.aid = B.bid_aid

raw query in query analyser works a treat:

1aaaaaaaaaaaaaaaaaa ...

Hi all

Note that:

dbcc freeproccache

exec sp_recompile ccccc

all didnt work to resolve it, edit the view in EM, add a space, OK.. and all is fine again.

Cheers

Ck

Hi there

One item you may have overlooked - its important to remember that the "user experience" in all of this is poorly served in both areanas of dbms's. For...

Hi Steve

Good point to bring up actually.

This sort of concept comes from the oracle world, but were see a clearer distinction between "user" and "owner" of objects. Here in...

Hi there

I kicked all users

Put DB into single user mode..

dbcc checkdb('corpsys', REPAIR_REBUILD) with ALL_ERRORMSGS

We had repeated errors over some objects, each run produced a range of user dumps. The...

Hi Brian

Yep, deal with this one regularly and its real pain if there are large numbers of stored procs and you have inherited a system where "dbo" privs are the...

Hi there

Its common amongst enterprise developers that XML IN/OUT strings are used as parameters for class methods. As such, you see the custom wrappering of a record set (non-xml...

Hi there

I believe they do, especially if the so called "parameter sniffing" feature of sqlserver is still around. Run something like this for example:

DBCC SHOW_STATISTICS (mytable, PK_MyPrimaryKey)

this returns info...

whoops! forgot that one 🙂 and for some sites its a big issue.

Hi All

See this:

http://groups.google.com/groups?q=%22parameter+sniffing%22+%22bart+duncan%22++group:microsoft.public.sqlserver.*&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sqlserver.*&selm=uBWmjRecBHA.163%40cppssbbsa01.microsoft.com&rnum=10

and this from Brian Moran:

Actually... this is expected behavior and has been since SQL 4.2.

Here's what is probally happening...

Oddly enough... changing the number of rows returned by a...

Hi there

At the end of the day, think "simplicity". Log shipping is very simple, and yes, you can get small glitches from time to time (typically related to disk space...

Hi

Even a simple check, like comparing a dual AMD MP2000 with p4 3Ghz sees, most of the time, the dual box leading the way, hyper-threading or not. The key...