Viewing 15 posts - 33,586 through 33,600 (of 49,552 total)
Are you talking about the Master Data Management features of SQL Server 2008 R2?
Do you have an environment complex enough to make use of that (multiple databases with related information,...
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
March 9, 2010 at 1:13 pm
Not specific on the AND/OR problem, but why reinvent the wheel?
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
March 9, 2010 at 12:49 pm
Yes. Say there's a single drive failure, or database corruption, or someone stops SQL and deletes one of the files belonging to a system DB. Restoring from backup is far...
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
March 9, 2010 at 11:49 am
It's a test.
Telling SQL to wait 20 sec is an easy way for an attacker to tell if the system is vulnerable to SQL injection. If it is, 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
March 9, 2010 at 10:31 am
If you use the code but don't get a ticket with your conference badge, speak to the ppl at registration. Stuff does sometimes get forgotten, but they're very good at...
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
March 9, 2010 at 7:38 am
Integrity check? SQL doesn't do an integrity check on startup. The checkDB messages in the log on startup just report the last time checkDB ran successfully.
If you're talking about slow...
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
March 9, 2010 at 7:10 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
March 9, 2010 at 7:05 am
Restore from backup if you can.
A repair might cause problems with sharepoint because of the way it discards data. Not sure here, I have asked an expert on corruption 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
March 9, 2010 at 7:05 am
sql_lock (3/9/2010)
Show this "so called" dba that the likes of @Gail (extremely well respected in the SQL community!) say he's wrong...
http://en.wikipedia.org/wiki/Argument_from_authority
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
March 9, 2010 at 6:48 am
The Wall (3/9/2010)
You are right, but this person calls himself our system administrator/ dba.
Regardless of what he is, it's hard to argue with tests that prove what you're...
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
March 9, 2010 at 6:31 am
Write a stored proc that will do the purging, test that it doesn't kill the transaction log in the process, then go to whoever is responsible for scheduled jobs 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
March 9, 2010 at 6:28 am
Dave Schutz (3/9/2010)
30 minute sit down session with an MVP
That's not much of a prize.
During the main conference you can't swing a (metaphorical) cat without hitting a couple of...
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
March 9, 2010 at 6:21 am
That's a rather vague question.
Honestly a well-designed and well-tuned database won't slow down as rows are added. Consider partitioning if you can on the large tables, evaluate the partition columns...
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
March 9, 2010 at 5:57 am
The Wall (3/9/2010)
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
March 9, 2010 at 5:10 am
exec sp_spaceused
Called without parameters it gives details for the DB as a whole, when passed a table name gives details for that table.
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
March 9, 2010 at 5:08 am
Viewing 15 posts - 33,586 through 33,600 (of 49,552 total)