Viewing 15 posts - 43,996 through 44,010 (of 49,552 total)
just.jelena (10/6/2008)
My database is in 'simple' recovery mode and the backup is running every night...
If you're in simple recovery, then running a truncate log will do almost nothing. 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
October 6, 2008 at 10:10 am
Certain features (merge replication, filestream) require the presence of a rowguidcol in the table. Other than that, nothing that I'm aware 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
October 6, 2008 at 10:02 am
Sure it is, but that's not going to add rows for months that aren't in the original 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
October 6, 2008 at 9:54 am
No need for dynamic SQL at all.
CREATE TABLE #AgeList (
Age tinyint
)
IF @PropType = 'Student'
BEGIN
INSERT INTO #AgeList (Age)
...
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
October 6, 2008 at 9:50 am
You can't programatically control what triggers fire.
Write a single trigger that has logic to be able to send the different types of mail. It doesn't really sound complex. Bear...
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
October 6, 2008 at 9:42 am
It's an orphaned distributed transaction. Basically something has cancelled a distributed transaction badly and SQL's left with locks it doesn't know what to do with.
You can kill them safely, unfortunately...
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
October 6, 2008 at 9:37 am
First thing you need to to get management's buy-in for the tightening of security. The people who currently have privileged access aren't going to want to give it up, 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
October 6, 2008 at 9:24 am
No relationship.
Isolation levels affect how long locks are kept within a transaction and how isolated changes made by one transaction are from another transaction.
Indexes speed up data retrieval by giving...
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
October 6, 2008 at 9:23 am
I'll probably hear a day or so after it's available. If I hear anything, I'll let you know.
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
October 6, 2008 at 9:20 am
See if you can pick up a 2008 licence. I don't know if there's a difference in pricing, but picking up a 2008 server to act as the distributor gives...
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
October 6, 2008 at 9:15 am
Dugi (10/6/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
October 6, 2008 at 9:13 am
That's an immensely wide question. It's like asking which is better, a peppermint milkshake or an espresso.
Are you asking theoretically? Are you trying to decide for a project? What's 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
October 6, 2008 at 7:34 am
Why no good backup?
If checkDB with repair is not working, then your only remaining option is to script out the DB, bcp out what data you can (some won't export...
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
October 6, 2008 at 7:29 am
That's not because of the datalength needs to be multiplied by 2. It's because the /2 is outside the CASE statement but only applies to the ELSE portion of 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
October 6, 2008 at 7:25 am
@@identity will get you the identity value that you just inserted. MAX(ID) will get you the last value inserted. If multiple users cn be inserting at the same time, 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
October 6, 2008 at 7:15 am
Viewing 15 posts - 43,996 through 44,010 (of 49,552 total)