Viewing 15 posts - 15,076 through 15,090 (of 18,923 total)
instead of triggers were introduced in sql 2k. What's the problem with the code you created?
July 13, 2005 at 11:40 am
I never had to either... but I can see the need. Imagine that the server can't keep up with the demand and has to queue to inserts of the...
July 13, 2005 at 11:37 am
I didn't check the link, but this might give you what you need :
Create table...
GO
exec sp_addextendedproperty N'MS_Description', N'This table must contain ONLY 1 LINE or Facturation.adp.Km (form) will start...
July 13, 2005 at 11:35 am
Yes I speak french. Also if the method Ray posted doesn't work we'll need some sample data you need to generate.
July 13, 2005 at 11:32 am
Here's the rest of mine if anyone's interested :
CK : check constraint
DF : default constraint
FK : Foreign key --for objects and columns
PK : Primary key --for objects and columns
fn...
July 13, 2005 at 11:31 am
Usually for sampling. Something like an election where you want to get an estimate every X minute without recompiling everything. But there are always other methods to do...
July 13, 2005 at 11:23 am
That's where you see who's the boss on the server
.
July 13, 2005 at 11:20 am
ok, ok, I'll give you my vote if you insist.. Send the t-shirt at the same adress as all the books I ordered
.
July 13, 2005 at 10:26 am
Select * from Information_schema.columns where table_name = 'TableName'
July 13, 2005 at 10:25 am
Search the script section on this site... you'll find what you need.
July 13, 2005 at 10:24 am
Ya, 33k records can cause a lot of page reads if it's fragmented... but not as much as an useless scan
.
July 13, 2005 at 10:23 am
... and everyone else who followed the same course as I did so that would be a few hundreds
.
July 13, 2005 at 10:06 am
HTH.. Please post back your findings... I want to see how this turns out
.
July 13, 2005 at 10:03 am
![]()
CREATE TABLE [ObjADPSUsage] (
[PkObjADPUsage] [int] IDENTITY (1, 1) NOT NULL ,
[FkObjADP] [int] NOT NULL ,
[DateUsage] [datetime] NOT NULL CONSTRAINT [DF_ObjADPSUsage_DateUsage] DEFAULT (getdate()),
[FkUser] [int]...
July 13, 2005 at 10:00 am
I already posted something like that. Look carefully at the where in the clustered scan. You'll most likely find the condition to be something like this : where...
July 13, 2005 at 9:46 am
Viewing 15 posts - 15,076 through 15,090 (of 18,923 total)