Viewing 15 posts - 391 through 405 (of 1,162 total)
Eugene Elutin (5/10/2012)
...
Depends on the reason for it. If the reason for preventing DML is to avoid long locks when another process is running, an after trigger doesn't help at...
May 10, 2012 at 7:37 am
Divine Flame (5/10/2012)
HowardW (5/10/2012)
Depends on the reason for it. If the reason for preventing DML is to avoid long locks when another process is running, an after trigger doesn't help...
May 10, 2012 at 6:46 am
Eugene Elutin (5/10/2012)
I wouldn't use "Instead Of" trigger for that. The standard one for "after insert,update,delete" will do as fine with much less coding...
Depends on the reason for it. If...
May 10, 2012 at 6:22 am
I don't think you're explaining yourself very well, but I'll take one more stab at it:
SELECT *
FROM personnel
WHERE maas = ( SELECT TOP 1
...
May 10, 2012 at 4:15 am
I still don't quite get your criteria, but are you looking for something like this:
SELECT *
FROM personnel
WHERE maas > ( SELECT TOP 1
...
May 10, 2012 at 3:56 am
Agreed. To give examples of how to do this more efficiently (this is true of SQL Server or Oracle), a couple of examples below:
Using the "proprietary" UPDATE...FROM... syntax in SQL...
May 10, 2012 at 1:56 am
It would definitely be more elegant to use the Google Analytics API (this has .Net libraries you can download and it looks pretty simple to interface with), then use a...
May 9, 2012 at 5:32 am
Mark-101232 (5/8/2012)
select b.value('@UNIT_ID', 'nvarchar(100)'),
r.value('@DT', 'DATETIME'),
r.value('@V', 'decimal(10, 8)...
May 8, 2012 at 10:09 am
Traversing parents is really slow in XQuery. If you're dealing with one massive document, rather than an XML column across many rows, use OPENXML instead, which will, comparatively, smoke it:
DECLARE...
May 8, 2012 at 9:36 am
I'm pretty sure a truncate will always result in a TABLOCK until the transaction is committed. Rather than using a partitioned view (even if you somehow got around the table...
May 8, 2012 at 5:50 am
I think the confusion here is that the Windows API allows files to be defragmented online since Win2k3, but you'd need a 3rd party tool that supported it. The built...
May 4, 2012 at 10:29 am
On points 3 and 4, I'm not sure you're going to find much real-world experience of this setup - it sounds pretty niche.
On the one hand, SSD's can be blindingly...
May 3, 2012 at 8:07 am
Worth having a look at Gianluca's article about date formatting here[/url], which covers how this is made much easier in 2012 and also includes a CLR formatter example. If you're...
May 3, 2012 at 5:30 am
Sorry, misunderstood your requirement. If you set the derived column error output to "Ignore Failure" on truncation then you can use:
(DT_DBTIMESTAMP2,3)(DT_DBTIMESTAMP2,0)GETDATE()
April 30, 2012 at 4:19 am
Pretty simple:
(DT_DBTIMESTAMP2,3)GETDATE()
April 30, 2012 at 4:09 am
Viewing 15 posts - 391 through 405 (of 1,162 total)