Viewing 15 posts - 21,391 through 21,405 (of 49,552 total)
MasterDB (1/4/2012)
Here the thing is i want to access and needs to do modifications in QA Database server.
Then you can't use backups for this, you'll have to go for scripts...
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
January 4, 2012 at 2:06 am
kapfundestanley (1/4/2012)
What's wrong with running a maintenance plan thats does log back-ups for my databases and store in a folder on the same machine.
Other than the fact that if the...
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
January 4, 2012 at 1:57 am
jswong05 (1/3/2012)
This article again shows SQL Server's shortcomings.1) default to full recovery mode (Oracle is opposite)
Default is whatever model is set to. If you want new databases defaulting to simple...
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
January 4, 2012 at 1:56 am
RLB (1/3/2012)
The only time a log should be shrunk is if some abnormal database activity (or failed log backups) has resulted in the log growing far beyond the size 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
January 4, 2012 at 1:52 am
Robert J. Browning (1/3/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
January 3, 2012 at 3:54 pm
Is what info cached?
If it says a proc is being passed too many parameters then somewhere in the trigger or in the procedure it calls (or in a procedure 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
January 3, 2012 at 2:51 pm
sys.dm_tran_active_transactions joined to dm_tran_session_transactions joined to sys.dm_exec_sessions for the details of who and from where. May need exec_connections with the last sql handle column (not exact, it's something like that)
sys.dm_tran_locks...
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
January 3, 2012 at 2:48 pm
Glenstr (1/3/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
January 3, 2012 at 2:27 pm
No. All operations are logged always. There is no way to disable logging, whether at a database or a table level.
If you're in full recovery model, index rebuilds are fully...
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
January 3, 2012 at 2:13 pm
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
January 3, 2012 at 2:05 pm
have2much (1/3/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
January 3, 2012 at 2:03 pm
Divine Flame (1/3/2012)
I must say, I can't speak for a week on performance tuning...
5 day course on performance tuning: http://www.sqlskills.com/T_ImmersionPerformanceTuning.asp
And note that that course is purely on the admin side....
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
January 3, 2012 at 12:41 pm
Ah, in that case it's a hell of a lot simpler. The login's still there, it's just failing to open the default DB.
Open management studio. New query. The connection dialog...
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
January 3, 2012 at 12:38 pm
Divine Flame (1/3/2012)
I would request them (the bosses) again to postpone it for few weeks but don't know if they will agree :hehe:.
Well, it's that or you buy materials (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
January 3, 2012 at 12:20 pm
Brandie Tarvin (1/3/2012)
Stefan Krzywicki (1/3/2012)
GilaMonster (1/3/2012)
Brandie Tarvin (1/3/2012)
So I'm searching on thin clients and SQL Server and come up with this little gem:http://www.sql-server-performance.com/2000/implementing-oltp-environment/%5B/url%5D
It's an almost 12 year old article, so...
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
January 3, 2012 at 12:13 pm
Viewing 15 posts - 21,391 through 21,405 (of 49,552 total)