Viewing 15 posts - 29,371 through 29,385 (of 49,552 total)
I would certainly hope it doesn't work, because if it did it would mean that any person in the world could attempt to access your SQL Server.
Speak to the network...
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
November 15, 2010 at 2:13 am
If everyone is using the sa login, you cannot in any way prevent them from seeing or doing what the want on any database on the server.
sa (and in fact...
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
November 15, 2010 at 2:12 am
If everyone's using the sa account, then everyone has access to everything. Login names (and passwords) are server-level, not database level, and anyone who's a member of sysadmin (including sa)...
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
November 14, 2010 at 10:38 pm
I should check details before posting. the 20000 I remembered was page count, not row count.
900 byte key + 500 byte include. 96000 rows. 19001 pages in leaf. 8 levels...
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
November 14, 2010 at 10:14 pm
Need to check. Was 7 levels + leaf, that I know, was not 2 million rows, that I also recall. May have had an include, can't recall. Was for 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
November 14, 2010 at 10:05 pm
Grant Fritchey (11/14/2010)
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?I might go.
Might go? Aren't you presenting there?
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
November 14, 2010 at 8:55 am
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?
No. Too much travel tentatively planned for next year already.
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
November 14, 2010 at 8:53 am
What error is it giving you?
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
November 13, 2010 at 12:32 pm
Without seeing what exactly those errors are, no way to tell.
Did you recreate all the procedures, functions, views etc that may have been there?
Was recreating the DB necessary? No good...
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
November 13, 2010 at 12:31 pm
Because the second says 'truncate the log without backing it up, discard all inactive log records'. Since the log records have been discarded (not backed up), the log chain is...
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
November 13, 2010 at 8:38 am
No. You cannot restore down-version, never have been able to.
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
November 13, 2010 at 2:48 am
caladba (11/12/2010)
Does anyone know the reasoning behind the max size being 900 bytes?
Could just be one of those chose numbers from early, early in history. Might have something to...
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
November 13, 2010 at 2:48 am
Please post new questions in a new thread
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
November 13, 2010 at 2:10 am
Tell the boss that to maintain user satisfaction and acceptable overall performance you would prefer to set up a replica (replication or mirroring with snapshot) of the production server 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
November 12, 2010 at 1:00 pm
Trace for errors. I think what you want is the attention event, possibly coupled with sp:starting.
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
November 12, 2010 at 12:57 pm
Viewing 15 posts - 29,371 through 29,385 (of 49,552 total)