Viewing 15 posts - 28,816 through 28,830 (of 49,552 total)
Not an emulator. A virtual machine or similar. There are several for the MacOS, just search around.
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
December 18, 2010 at 6:01 am
No. SQL works on Windows only. If you want to use SQLon a mac, you need some dual boot or virtualisation that lets you run the windows operating system.
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
December 18, 2010 at 5:01 am
The isolation levels are trade-offs. Isolation and consistency vs concurrency. Pick the one that you need for your system. Read committed is usually a decent default, but it does depend.
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
December 18, 2010 at 1:04 am
pavan_srirangam (12/17/2010)
1. In sp_configure Truncate log on check point -enable it
Truncate log on checkpoint has been deprecated since SQL 7. It should not be used any longer. On...
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
December 18, 2010 at 1:02 am
Gianluca Sartori (12/17/2010)
I feel a bit ignorant now... :blush:
Not intended, sorry. Back in those days I was quite into hardware and read a lot up on the processor architectures.
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
December 17, 2010 at 11:11 am
I suppose the important thing here is why the mismatch in row estimates.
Can you maybe start a new thread and post the query in question and the execution plan please?
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
December 17, 2010 at 10:11 am
CirquedeSQLeil (12/17/2010)
I see an x86 and amd64 version. Too bad they don't have an intel 64 bit version.
The x64 processor architecture is sometimes known as AMD64 because AMD came...
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
December 17, 2010 at 10:11 am
See the output of OPENTRAN that you posted earlier.
Transaction information for database 'CareCast'.
Oldest active transaction:
SPID (server process ID): 55
UID (user ID) : -1
Name : ggs_repl
LSN : (33114:57895:4)
Start time :...
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
December 17, 2010 at 10:08 am
Could you put the question in context please? What are you doing and what's the exact error that you get?
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
December 17, 2010 at 7:48 am
Imke Cronje (12/17/2010)
I can't post that information:
It's very hard (near impossible) to provide correct advice on performance problems without seeing what I asked for. Without knowing what the table looks...
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
December 17, 2010 at 7:41 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
December 17, 2010 at 1:47 am
Malcolm Daughtree (12/16/2010)
I have no Idea ... another myth that needs debunking..
Which are you saying is the myth? That the clustered index scan does always return in order or 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
December 16, 2010 at 4:22 pm
1) Parallelism
2) Allocation order scan with a fragmented index.
3) Advanced scan (merry go round). This one's hard and I've never personally been able to repo 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
December 16, 2010 at 3:57 pm
Ok... Give this a try, see if it lets you get the DB back. If not, you're out of luck.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
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
December 16, 2010 at 3:17 pm
And with the log?
The more info you give the more likely it is that someone can help. If you're vague we're just going to keep asking for more and...
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
December 16, 2010 at 3:04 pm
Viewing 15 posts - 28,816 through 28,830 (of 49,552 total)