Viewing 15 posts - 39,751 through 39,765 (of 49,552 total)
Pieter (4/14/2009)
Msg 15274, Level 16, State 1, Line 1Access to the remote server is denied because the current security context is not trusted.
Gut feel is that's due to the linked...
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
April 14, 2009 at 1:21 pm
Lynn Pettis (4/14/2009)
Gail, see the latest on this one you were just on?
I saw it. I had a half-written, very snarky reply that I deided was better not posted. Besides,...
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
April 14, 2009 at 1:17 pm
Does it throw an error, or just not do something that it's supposed to?
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
April 14, 2009 at 1:02 pm
<Sigh>
http://www.sqlservercentral.com/Forums/Topic696113-92-1.aspx
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
April 14, 2009 at 12:57 pm
It's very hard to say what causes a dip in cache hit ratio. In fact it's difficult to work out when sitting in front of the server with full access...
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
April 14, 2009 at 12:54 pm
That doesn't tell us anything.
In fact, I can't give you a hard and fast number for how often anything should be done.
Backup frequency: depends on your SLAs and your acceptable...
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
April 14, 2009 at 12:52 pm
What you're seeing there is the code that Management studio is running to get the results displayed by Activity Monitor. That's what management studio runs when you look at a...
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
April 14, 2009 at 12:39 pm
ReadUncommitted and NOLOCK have the same effect. Only difference is that specifying SET TRANSACTION ISOLATION LEVEL READUNCOMMITTED affects every single table within a select statement until the connection closes or...
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
April 14, 2009 at 11:48 am
The answer to all three is whatever you specify, nonclustered by default.
ALTER TABLE ... ADD CONSTRAINT ... UNIQUE CLUSTERED -- creates a clustered index to support the unique constraint. Will...
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
April 14, 2009 at 11:44 am
Jackal (4/14/2009)
However I was just wondering on the exact mechanism that SQL will use to resolve these, will it utilise tempdb for this operation?
No, it's just a table...
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
April 14, 2009 at 9:01 am
ANSI - American National Standards Institute. It's an organisation that sets standards
ACSII - American Standard Code for Information Interchange. It's a standard for encoding of characters in binary.
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
April 14, 2009 at 4:57 am
ChandaMAMA (4/14/2009)
Its...
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
April 14, 2009 at 4:54 am
Did you read those articles?
If, in your example, you have an index on FName and a second index on LName, then your query may be able to use one of...
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
April 14, 2009 at 3:31 am
It can, providing that the query doesn't return too many rows.
Have a read through these, they're not beginner-level articles, but they may be of use.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
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
April 14, 2009 at 2:22 am
grngarlapati (4/14/2009)
like
select ID,(exec Proc ID) as Name from Table
I dont...
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
April 14, 2009 at 2:09 am
Viewing 15 posts - 39,751 through 39,765 (of 49,552 total)