Viewing 15 posts - 20,641 through 20,655 (of 49,552 total)
If it makes you feel better, that exact scenario stumped me for more than a day a while back.
No delete thread button, was removed after too many people deleted threads...
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
February 1, 2012 at 12:49 pm
Star Trek (2/1/2012)
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
February 1, 2012 at 12:42 pm
itmasterw 60042 (2/1/2012)
I have two questions on locking?
First, I just wanted to make sure, if you have a table with say customer information (names and address etc.), and multiple people...
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
February 1, 2012 at 12:35 pm
Is the table in question empty?
Is the index_id possibly 0 (a heap)?
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
February 1, 2012 at 12:33 pm
No. It's an option, and it makes some sense (especially when there are multiple filegroups and splitting is done for recoverability reasons), but it is by no means a universal...
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
February 1, 2012 at 12:32 pm
SQLKnowItAll (2/1/2012)
What happens when you put your where conditions into your join?
If you're talking about the update, nothing will happen. It's an inner join, conditions in the where or join...
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
February 1, 2012 at 12:04 pm
DBA_Dom (2/1/2012)
In mirroring the log cannot be reused until a log backup occurs.
That's true for any time the DB is in full or bulk-logged recovery, not just when there's...
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
February 1, 2012 at 11:52 am
One thing I did notice is that the memory grant for the hash join is much smaller on production. Possibly greater workload so less available memory. Have you checked for...
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
February 1, 2012 at 11:52 am
The plans are identical, so it's not missing indexes or anything like that.
Have you checked for blocking when it runs slow? Have you checked what the wait_type is when it...
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
February 1, 2012 at 11:49 am
Please ask someone who does have sufficient permission to get the actual execution plan from the production server.
Is that the entire query? No filters, no aggregation?
Have you tried exists, since...
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
February 1, 2012 at 10:21 am
Steve Jones - SSC Editor (2/1/2012)
GSquared (2/1/2012)
HowardW (2/1/2012)
Not sure whether to call it spam or not, but most of his posts...
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
February 1, 2012 at 8:54 am
Null is not equal to null, however a unique constraint only allows one null. It simply means that unique constraints only allow a single null, it does not mean 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
February 1, 2012 at 8:47 am
Question is, how far do you go?
Just char, varchar, nchar, nvarchar, binary, varbinary?
Also decimal and numeric (default is numeric(18,0))?
Also time (default is time(7)), datetime2 (default is datetime2(7)) and datetimeoffset (default...
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
February 1, 2012 at 8:01 am
Where is the description of the procedure stored? Part of the proc's definition?
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
February 1, 2012 at 6:58 am
Is the object in the <username> schema?
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
February 1, 2012 at 6:21 am
Viewing 15 posts - 20,641 through 20,655 (of 49,552 total)