Viewing 15 posts - 4,816 through 4,830 (of 6,041 total)
djackson 22568 (8/19/2013)
Eric M Russell (8/19/2013)
It must be daunting for a software vendor like Oracle to
Not a fan of Oracle right now. I understand that they no longer...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2013 at 8:59 am
Steve Jones - SSC Editor (8/19/2013)
And another view, somehow timed to come out with mine: http://blogs.lessthandot.com/index.php/ITProfessionals/ProfessionalDevelopment/microsoft-isn-t-the-devil
When it comes to complaints leveled against Microsoft from the general development community about software...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2013 at 8:42 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 19, 2013 at 7:10 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 16, 2013 at 9:21 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 14, 2013 at 11:50 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 9, 2013 at 9:12 am
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%'
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 7, 2013 at 11:05 am
Franklin's Gambit says that we often use data and explanations to justify a decision we've already reached, rather than actually prove that some choice is the best one.
This tendency...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 7, 2013 at 9:23 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 6, 2013 at 9:33 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 6, 2013 at 8:32 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 6, 2013 at 8:06 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 6, 2013 at 7:49 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 6, 2013 at 7:44 am
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 5, 2013 at 3:48 pm
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 5, 2013 at 7:30 am
Viewing 15 posts - 4,816 through 4,830 (of 6,041 total)