Viewing 15 posts - 34,501 through 34,515 (of 49,552 total)
Doesn't matter how unique the fields are.
I'm not talking about the update in the trigger, I'm talking about the insert/update that fires the trigger.
If anyone ever inserts or updates more...
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 22, 2010 at 5:49 am
h.wijnbergen (1/22/2010)
And now it works, anyway thanks for your comments.
It's still not going to work properly if you insert or update more than one row at a time.
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 22, 2010 at 4:57 am
Could you post the definition of the bltTssVeh table please?
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 22, 2010 at 4:55 am
Two options.
1) Create a primary key on those columns.
2) Create a surrogate pk (int identity perhaps) and then put a unique constraint on those two columns.
There's lots of debate which...
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 22, 2010 at 4:47 am
Query the sys.columns view. Join it to sys.tables for the table name, or use the object_name function.
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 22, 2010 at 4:44 am
parthi-1705 (1/22/2010)
ALTER TABLE MYTABLE ADD date DATETIME
go
ALTER TABLE dbo.MyTABLE ADD CONSTRAINT
DF_MyTABLE_date...
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 22, 2010 at 4:41 am
Because of the index rebuild. It touches every row of every table, and all of that is logged
Two questions on your maint plan.
Why are you rebuilding and reorganising? Rebuild does...
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 22, 2010 at 4:14 am
You're missing half of your insert statement. It needs to be one of the following forms.
INSERT INTO ...
SELECT ...
or
INSERT INTO ...
VALUES ...
Other than that, there's nothing I can see wrong,...
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 22, 2010 at 3:53 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/Topic845221-145-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 22, 2010 at 3:49 am
Is this homework? If not, what are you trying to get here? I don't understand the reason.
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 22, 2010 at 3:48 am
dp-01 (1/22/2010)
My query is to get the created date of all the records in a particular table .Is it...
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 22, 2010 at 3:46 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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 22, 2010 at 3:44 am
No.
Disaster recovery plans are specific to the scenario you have. Your servers, your setup, what kind of high availability you have, what kind of downtime and data loss is acceptable,...
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 22, 2010 at 3:43 am
You don't specify a data type when creating a computed column. The data type depends on the result of the expression.
Create table #Test (
emp_id int,
emp_Birth_Date DATETIME,
emp_Age AS datediff(d,emp_Birth_Date, 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 22, 2010 at 3:03 am
ang-473999 (1/21/2010)
I set the switch last night. The error log showed a long deadlock-list which is decoded in my post above.
Post it please (as an attachment if it's big)....
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 22, 2010 at 2:18 am
Viewing 15 posts - 34,501 through 34,515 (of 49,552 total)