Viewing 15 posts - 43,951 through 43,965 (of 49,552 total)
On that one you'll have to wait until the portion of the log that's in use is at the beginning of the file. You can force that by creating 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
October 7, 2008 at 2:28 pm
sahmad43 (10/7/2008)
exec sp_addextendedproc 'ABCAD', 'FADSFADFASF'
Server: Msg 2714, Level 16,...
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
October 7, 2008 at 1:42 pm
Well, there's only 3% free space in the log, so I think the first thing that we need to do is figure out why the log is full.
Let me guess....
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
October 7, 2008 at 1:37 pm
Lynn Pettis (10/7/2008)
On very large tables, the index scan and bookmark lookup can be faster.
You sure about that? I can see an index scan been marginally faster than...
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
October 7, 2008 at 1:35 pm
Lynn Pettis (10/7/2008)
I'm poor and don't have an MSDN subscription, so I pay "retail" for the developer edition.😎
Oh I didn't buy an MSDN subscription. No way I could afford 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
October 7, 2008 at 1:31 pm
Grant Fritchey (10/7/2008)
It's on Connect. If you want to confirm it or track it, go here.
I would, but there seems to be a bug with connect. I can only see...
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
October 7, 2008 at 1:28 pm
tendayit (10/7/2008)
Users can enter a full accountid, idnumber, etc and retieve an account but they can also do partial searches where they put in a string say on the account...
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
October 7, 2008 at 1:13 pm
Lynn Pettis (10/7/2008)
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
October 7, 2008 at 1:11 pm
Lynn Pettis (10/7/2008)
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
October 7, 2008 at 1:10 pm
Rod at work (10/6/2008)
I'm wondering, is that possible? Is it possible to restore a database from one location to another from a snapshot on the old database server?
No. Snapshots...
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
October 7, 2008 at 8:15 am
tendayit (10/7/2008)
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
October 7, 2008 at 8:12 am
Jeff Moden (10/7/2008)
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
October 7, 2008 at 8:11 am
Denby (10/7/2008)
Wilfred van Dijk (10/7/2008)
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
October 7, 2008 at 8:08 am
That query still can't use any indexes due to the leading wildcards on almost all of the filters.
Do your users really enter middle portions of account numbers, phone numbers 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
October 7, 2008 at 8:06 am
The query I was trying is even simpler:
select CarrierTrackingNumber, ProductID, OrderQty, UnitPrice from Sales.SalesOrderDetail where CarrierTrackingNumber = '8639-4639-AA'
Missing indexes picks up that (CarrierTrackingNumber) INCLUDE (ProductID, OrderQty, UnitPrice) would be extremely...
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
October 7, 2008 at 7:02 am
Viewing 15 posts - 43,951 through 43,965 (of 49,552 total)