djackson 22568 (8/19/2013)

Not a fan of Oracle right now. I understand that they no longer...

When it comes to complaints leveled against Microsoft from the general development community about software...

It must be daunting for a software vendor like Microsoft or Oracle to sort through thousands of bug reports and suggested feature requests. I do think that ISV or shareware...

After reading the entire article, I'm left with the impression that this guy is smart enough and can be personable when he tries, but he sounds like a "Millennial" or...

Rather than inserting into one table, another option would be to create a virtual table using a partitioned view.

create view v_WhatsUp_Assyst

as

SELECT nDeviceID, nDefaultNetworkInterfaceID FROM WhatsUp_Assyst_replicatie.dbo.device

union all

SELECT nDeviceID, nDefaultNetworkInterfaceID FROM WhatsUp_Assyst_replicatie2.dbo.device

union...

I have a job kicks off every 5 minutes and queries active requests and joins session info, t-sql statement, cpu/io/duration, etc. into a table on my local instance. Also, a...

You can search text in syscomments table like so:

SELECT DISTINCT so.name

FROM syscomments sc

INNER JOIN sysobjects so ON sc.id=so.id

WHERE sc.TEXT LIKE '%UKSQL01%'

This tendency...

In addition to reading blogs and forums, I spend a lot of time listening to audio podcasts while commuting in the car. I'm surprised no one has mentioned Microsoft's Channel...

I'm not certain what formatting "####0" represents, it could be padding with spaces or zeros, but basically it would be a CASE expression like so:

case inc_data.event_type

when 'c' then 'R'+left('00000'+cast(incident.incident_ref...

The SELECT won't be blocked, unless the SELECT attempts to read a page that has some type of exclusive lock on it. Update locks are generally at page level, unless...

Perhaps the table column you're inserting into needs an identity property. If you must define number externally, then use row_number() or insert into temp table containing identity column, and then...

When you display execution plan in SSMS, does it suggest any new index?

From what I see, it could at least use an index on Mark_No, but query plan analyzer may...

taigovinda (8/2/2013)

I have a concatenated field that is usually about 80 characters but sometimes has been up to 600 characters. It could conceivably be longer than that. How...

My portable toolbox includes a USB to SATA/IDE adapter, so I can easily pop the HD out of one laptop or PC and mount it on another, and it's useful...