Viewing 15 posts - 39,946 through 39,960 (of 49,571 total)
It's not a bug, maybe a limitation. The event you mention cannot be used with DDL triggers. It can (iirc) be used with event notifications, so that may be a...
April 7, 2009 at 3:12 am
Sheng (4/6/2009)
I'm not under hard-pressure:) Currently, I just design my system to generate this "start of group" column in the client...
April 7, 2009 at 3:08 am
That's what CheckDB's there for. Preferably run regularly.
April 7, 2009 at 3:00 am
kramaswamy (4/6/2009)
wasn't aware that functions cause indexes to be unusable.
It's not that functions make indexes unusable, it's that any function on a column (any at all) means that...
April 6, 2009 at 4:19 pm
Paul White (4/6/2009)
April 6, 2009 at 4:10 pm
Your index seek (when you get it) is only on sourceID. FirstName and LastName cannot be part of the index seek operation because they're contained within functions.
Try this and see...
April 6, 2009 at 3:56 pm
Bob Hovious (4/6/2009)
April 6, 2009 at 3:04 pm
What's the logic for which row remains? For the first set of dupes, you had 021427 for Column1, for the second you had 021470.
This is trivial to do in...
April 6, 2009 at 2:59 pm
sturner (4/6/2009)
I always use this:select rowcnt from sys.sysobjects O JOIN sys.sysindexes I on O.id = I.id and indid = 1 where type = 'U' and name = 'TABLENAME'
That works, but...
April 6, 2009 at 2:15 pm
Bob Hovious (4/6/2009)
April 6, 2009 at 10:33 am
xgcmcbain (4/6/2009)
select max(s.name), count(c.columns) from sysobjects s inner join syscolumns c on s.name = c.name where type='table'
That'll get the number of columns, not of rows.
April 6, 2009 at 10:23 am
If you just want a quick and dirty, query sys.partitions
select object_name(object_id) AS TableName, sum(rows) AS TotalRows from sys.partitions
where index_id in (0,1)
group by object_id
April 6, 2009 at 10:19 am
Dean Jones (4/6/2009)
Also, I have read that one can use TRY/CATCH to do retries in order to solve deadlocking problems.
It won't solve the deadlock. It will just allow your code...
April 6, 2009 at 10:14 am
GilaMonster (4/6/2009)
J-F Bergeron (4/6/2009)
Now, they are asking me to insert that "Price calcullation" within a query that will be used in the products screen. So when they will query a...
April 6, 2009 at 10:12 am
Bob Hovious (4/6/2009)
I know I'm in the minority, but I think the practice of compiling and referring people to previous questions by the OP should be extended to new threads....
April 6, 2009 at 10:01 am
Viewing 15 posts - 39,946 through 39,960 (of 49,571 total)