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...
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
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(),
...
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...
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...
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
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...
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.
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...
January 20, 2010 at 5:58 am
talltop-969015 (1/20/2010)
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....
January 20, 2010 at 5:49 am
Please rather post new questions in new threads. Thanks
January 20, 2010 at 12:21 am
Tom Carnahan (1/19/2010)
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.
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...
January 19, 2010 at 1:28 pm
Viewing 15 posts - 34,561 through 34,575 (of 49,552 total)