I must admit its a tricky one, the cost of downtime because you tried to have some money on the hardware would be difficult to explain to your manager on...

Hi Steve

Yep, just submitted it. Funny enough, a lot of SS developers seem to think that identities for EVERY table is a great solution because it means less coding...

Hi there

I use this before running my data migration scripts for the bazillionth time...

SELECT 'DBCC CHECKIDENT (' + o.[name] + ', RESEED, 1)'

FROM syscolumns c

INNER JOIN sysobjects o ON o.[Id]...

Hi

I take the following approach:

a) P-keys are mandatory (dont cluster them unless they are cluster friendly and you will get the maximum benefit from them as its 1 per...

Hi all

Having come from the world of Oracle, SQL*Server 7 and 2k has been very impressive indeed. Under NT, I firmly believe SQL*Server is the only choice as Ive...

Hi there

Coming form an Oracle world, UDF's are very restrictive and tend to be a half cocked effort. I have this sneaking feeling that MS is not expending much...

I use it quite a bit and have noticed a small benefit. I have a range of security lookup tables etc and various reference data tables that I pin...

All I can say is... "dont make your life harder that it needs to be!"

Anyone who thinks coding t-sql, dmo, pouring over scripts manually is FUN and its necessary to...

Hi all

Good article Steve. I come from the Oracle world where a decent GUI was something i longed for over many years (for the record, Oracle enterprise manager and...

Steve

Thanks steve, I swear I played around with this and didnt seem to pick up everything.

I will give it another burl.

Cheers

Chris

Hi

Are you sure its doing incremental updates? have you got a timestamp column?

if not then incrementals will not work. On my server the disks get thrashed and CPU's...

Hi guys

We have the following in prod:

internet

|

firewall

|

ssl box

|

webserver (163.232.x)

|---------------domain controller (163.232.x)

sqlserver (10.10.10.3 private network)

|

disk-farm

we run a totally seperate domain for our prod environment, away from

the existing domain...

Steve

Hi Steve, I ment something like this:

truncate table infile_list

set @v_commandline = 'dir /B ' + @v_processeddest + '*.unl'

insert into infile_list

exec @result = master..xp_cmdshell @v_commandline

Where ive sent the output of the...

Hi

Although all possible via DTS, I tend not to use it as a "solution for anything that needs to be scheduled", although this will (perhaps) slowly change over time. ...

1000 rows is not only a limitation but a bug as far as im concerned 🙂

any ideas on another way to expose AD via views to app users?