Viewing 15 posts - 32,461 through 32,475 (of 49,552 total)
MAK-1128556 (6/14/2010)
p.s. there's no need for backup log .. truncate only on a database in simple recovery. Log will be auto truncated on checkpoint.it is not truncating the log.
If...
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
June 14, 2010 at 9:43 am
-- edit --
post irrelevant after the edit Sanjay made to his post.
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
June 14, 2010 at 8:53 am
Scott, Jeff could you possibly take your argument elsewhere please. It's getting a little off topic and we're likely scaring away a new member.
Thanks
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
June 14, 2010 at 8:50 am
Mirroring is per database, and the mirror database is inaccessible. Doesn't sound like that's what you want.
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
June 14, 2010 at 8:47 am
Why are you trying to shrink?
How much free space is in the log file?
What's the value of log_reuse_wait_desc in sys.databases for this DB?
p.s. there's no need for backup 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
June 14, 2010 at 8:46 am
Unless you were running some form of trace or audit at the time, it's highly unlikely you'll be able to trace what happened. SQL doesn't run data audits by default.
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
June 14, 2010 at 8:40 am
The Dixie Flatline (6/14/2010)
I'm hearing vuvuzelas in my sleep.
Me too.
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
June 14, 2010 at 8:31 am
Gil_Adi (6/14/2010)
Because the stored procedure that is beeing called works on create a pool of recrods and then process them one at a time
Why are you processing records one...
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
June 14, 2010 at 8:29 am
Dave Ballantyne (6/14/2010)
though you can probably set the permission level to 'external' , assuming this is CLR.
Threading requires unsafe.
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
June 14, 2010 at 5:18 am
Why are auto-create and auto-update statistics disabled? Are you manually managing your statistics?
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
June 14, 2010 at 5:18 am
Please don't crosspost. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic935796-1291-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
June 14, 2010 at 5:04 am
Extended stored procedure or CLR stored procedure?
Extended stored procs have to be written in C++ (not C#) and doing multi-threading in a C++ extended stored proc is very dangerous.
Assuming 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
June 14, 2010 at 5:02 am
If the exec plan is warning about missing statistics, you could easily be having sub-optimal performance. Is auto_create statistics enabled at the database level?
You didn't answer my question about whether...
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
June 14, 2010 at 4:56 am
DECODE is an Oracle function, not a SQL Server one. If this is an Oracle database, you'll get far better answers on an Oracle forum than a MS SQL Server...
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
June 14, 2010 at 3:23 am
Could be recompiles, could be there's some system process that's running at the same time either in SQL or windows.
Does the proc exhibit the same performance characteristics on the production...
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
June 14, 2010 at 3:23 am
Viewing 15 posts - 32,461 through 32,475 (of 49,552 total)