Viewing 15 posts - 121 through 135 (of 152 total)
Please read Thomas Kyte's books. He wrote for Oracle but the principles about "transaction processing" and "locking" and "index" are the same.
When FK records can be fastly located by...
November 11, 2009 at 7:58 am
Nice article, very elaborative.
I want to stress :
by improving performance, query will run faster and reduce required lock time, hence reducing blocking and deadlock posiibilities.
If you want to understand transaction...
November 9, 2009 at 10:17 am
1) code deploy to production server should not use select *
queries should be all in parameterized stored procedure A) each exec permission can be granted B) to prevent SQL injection...
November 6, 2009 at 12:44 pm
If a SOX Audit requires that an administrator on a Windows Server not be able to grant himself access to a SQL Server
That question is right on!!! (how much...
November 6, 2009 at 9:40 am
you are worried that someone is going to hack into your sql servers
That is correct for Joe in Finance. To prevent Joe from excessive previledge, you can worry less, he...
November 6, 2009 at 9:10 am
Got an idea for a great title for this one: how about....
"How to get in to SQL Server via back-door?" (because you don't have to use your regular account to...
November 5, 2009 at 7:11 pm
removing builtin\admin account is becoming more and more common.
It is interesting you mention that, you are right. We sure don't want an outsourced IT domain admin accessing databases unlimitedly. However,...
November 4, 2009 at 3:09 pm
How to connect to a sql server 2005 when build-in administrator account was removed?
My point is "lost sa password" is common. "build-in administrator account was removed" is not so common...
November 4, 2009 at 2:29 pm
You mentioned the title should be changed. What would you have called it? I think this title works very well. 10,000 plus hits here is very good indeed.
People look at...
November 4, 2009 at 1:53 pm
This article is based on the assumption that you still have server access (as a local admin or above?)
The content of discussion is good.
The title should change.
[Quote]Stop all the...
November 3, 2009 at 2:27 pm
A) not everybody can carry unused allocated space forever:-P.
B) before I move DBs to a different host or space volume, I would shrink it before I move it.:cool:
C) SQLServer has...
October 11, 2009 at 7:31 pm
If I understand Microsoft correctly, when mirrored, the transaction log got written to the mirror directly from memory (setting asynch or synch), so whatever happens to primary will happen to...
October 2, 2009 at 3:12 pm
COPY_ONLY option can be used anytime and the file can be taken away or disappeared without affecting LSN chain. If you take a full backup on-demand without using COPY_ONLY option,...
October 2, 2009 at 2:56 pm
Use this, to find all DBs both mdf and ldf, it generates shrink commands for you.
http://usa.redirectme.net/repriser/sqlserverpub.html
😛
October 1, 2009 at 10:03 am
Thanks for the effort. Since SPs are just ASCII text, a:w00t:ny diff program will do. diff.exe comes from windows free resource kit download. Any programmers should be able to diff.
October 1, 2009 at 9:56 am
Viewing 15 posts - 121 through 135 (of 152 total)