Viewing 15 posts - 46,531 through 46,545 (of 49,552 total)
Encrypted stored procs aren't hard to decrypt. Besides, if someone has the sa password, what stops them from conecting directly to the server and manipulating data?
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
May 16, 2008 at 12:05 am
jsheldon (5/15/2008)
I have changed sa but really what is stopping the person from going to AD, changing my password, then logging into SQL, change 'sa' then do damage
Nothing, but 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
May 16, 2008 at 12:03 am
karthikeyan (5/15/2008)
AWAITING COMMAND
That's an idle conection. TRy runing sp_who2 while the slow query is executing, see what waits/blocks you have
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
May 15, 2008 at 11:59 pm
You have lots of table scans. They ain't gonna be fast
@tmp_strategyid - A table variable? How many rows?
[MARKET_RISK_DB_US].[publish].[DIM_STRATEGY] - 3 table scans. How many rows?
[MARKET_RISK_DB_US].[publish].[DEAL_DTL] - 2 index seeks with...
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
May 15, 2008 at 11:52 am
jsheldon (5/15/2008)
Domain Admins never were a user to any databases (from our ERP down to Citrix) the blackberry server (4 dbs behind the scenes) had Domain Admin group as 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
May 15, 2008 at 11:42 am
Tell the boss it's an excellent learning opportunity. Tell him you will take details of all teh problems you're currently having and will sit with some MS developers and find...
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
May 15, 2008 at 11:34 am
Depends on the table. Heavy inserts tends to recommend a lower fill factor, while more static tables would probably have a higher fill factor.
It's far more important though to make...
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
May 15, 2008 at 7:30 am
Timothy Ford (5/15/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
May 15, 2008 at 6:35 am
Backing up he log doesn't change the size of the log file on disk. It just removes inactive log records (after backing them up) and clears space in the 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
May 15, 2008 at 12:42 am
Loner (5/14/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
May 15, 2008 at 12:35 am
What does the print for the dynamic SQL return? Or does that also return an error?
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
May 15, 2008 at 12:09 am
Did you comment the insert out as well?
This parses. It won't run, cause I don't have the tables, but it does parse.
CREATE TABLE #XYZ(
NTUser varchar(20),
FullNTName varchar(50),
FirstName varchar(20),
MiddleName varchar(20),
LastName varchar(40),
Rolename varchar(30))
DECLARE...
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
May 14, 2008 at 11:46 am
Replace the EXEC with a PRINT and have a look at what the constructed SQL statement is. You should be able to spot syntax errors fairly easily that way.
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
May 14, 2008 at 11:27 am
Please don't cross post. It just wastes people's time and fragments replies.
Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic500696-146-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
May 14, 2008 at 11:25 am
jamiejulius (5/14/2008)
In reference to the idea of changing the Recovery Model, are you suggesting that this would reduce the frequency and/or duration of the checkpoints?
No. It won't. All it will...
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
May 14, 2008 at 8:10 am
Viewing 15 posts - 46,531 through 46,545 (of 49,552 total)