Viewing 15 posts - 34,561 through 34,575 (of 49,552 total)
That was exactly my thinking when I started answering questions here. My thinking was that I was going to learn more by trying to figure out the answers to people's...
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
January 20, 2010 at 7:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic850417-291-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
January 20, 2010 at 6:58 am
No need for two updates or two triggers. That's just doubling the work SQL has to do.
ALTER TRIGGER [dbo].[trAddressCreateDate] ON [dbo].[Address]
FOR INSERT, UPDATE
AS
UPDATE Address
SET Created=getdate(),
...
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
January 20, 2010 at 6:57 am
Nabha (1/20/2010)
But I dont think trigger is the right way of handling it? You can just set the default values for these two columns in the table?
Defaults only apply on...
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
January 20, 2010 at 6:56 am
idiescreaming (1/19/2010)
They said that they are aware of DB inconsistencies caused by killing a process but they still wanna do it.
Killing a process will not cause database inconsistencies. SQL 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
January 20, 2010 at 6:55 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic849572-338-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
January 20, 2010 at 6:05 am
Do not ever delete the log file. It's not an optional component of the database. If you delete it, there's a good chance that the DB will not come online.
Was...
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
January 20, 2010 at 6:04 am
The resource database on SQL 2008 is not stored with the other system databases. It's stored with the binaries, as if it were a dll or exe.
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
January 20, 2010 at 6:01 am
You haven't given the most important information - the SQL error log. It's just a text file, no need for SQL to be running to access it. Find the 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
January 20, 2010 at 5:58 am
talltop-969015 (1/20/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
January 20, 2010 at 5:50 am
Markus (1/20/2010)
Couldn't one just 'pin' the tables in the specific database and that would hold them in memory? I have never done this but I have heard of it.
No....
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
January 20, 2010 at 5:49 am
Please rather post new questions in new threads. Thanks
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
January 20, 2010 at 12:21 am
Tom Carnahan (1/19/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
January 20, 2010 at 12:09 am
Use the NTEXT data type. It's stored out of row and the maximum is somewhere around 2 billion characters.
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
January 19, 2010 at 1:30 pm
jeffmc123452003 (1/19/2010)
that query was within sql studio
Doesn't matter what you're running it in. You are connected to a SQL 2000 server, that's why the maximum compatibility you can set 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
January 19, 2010 at 1:28 pm
Viewing 15 posts - 34,561 through 34,575 (of 49,552 total)