Viewing 15 posts - 16 through 30 (of 192 total)
What I'd suggest in this scenario is for the client to take the data required, and store the original data values. When the user issues a 'commit' at the...
June 23, 2010 at 10:21 am
June 16, 2010 at 9:41 am
blandry (6/14/2010)
Why, in all futuristic science fiction...
June 15, 2010 at 2:23 am
I'd advise against using sp_<procname> naming
It causes a performance overhead - and potentially unexpected outcomes. With sp_ proc names, the engine will first look in Master, then if it's...
June 10, 2010 at 6:49 am
I'd go for
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
May 14, 2010 at 3:28 am
Wallace Wood (5/7/2010)
...
The answer to the question, 'Is there some reason that this...
May 7, 2010 at 9:35 am
Flangeware - where the code appears to have been lashed together by a family of Baboons
May 7, 2010 at 2:24 am
Bhuvnesh (5/3/2010)
Paul White NZ (5/3/2010)
Bhuvnesh (5/3/2010)
yes this is partitioned tableI know - I was wondering why it is a partitioned *heap* rather than a clustered table. That's quite unusual.
...
May 4, 2010 at 7:31 am
Hi,
if I were you, rather than spend time reinventing the wheel generating and testing a script to do this, I would just use the following excellent...
April 23, 2010 at 10:04 am
Firstly - I'd personally have async set to on. With this option, a copy of the old stats are held while the new stats are being generated and used...
April 9, 2010 at 2:58 am
Steve Cullen (3/30/2010)
March 31, 2010 at 2:25 am
SSIS is your friend here. Lots of good tips, examples and advice on http://www.sqlis.com/
March 31, 2010 at 2:02 am
I'd see what tools your ERP solution provides for loading data into it, for example, loading a ledger entry, a sale etc. THere are often a lot of complex...
March 30, 2010 at 6:03 am
Bhuvnesh (3/30/2010)
Andrew Gothard-467944 (3/30/2010)
It's enabled by defaultyou are right, thanks for correcting me
np - we're all here to learn, glad to have helped
March 30, 2010 at 5:17 am
Bhuvnesh (3/30/2010)
Andrew Gothard-467944 (3/30/2010)
http://blogs.msdn.com/cindygross/archive/2009/12/16/sql-server-s-default-trace.aspx%5B/quote%5D But for this Default trace should be enabled Default trace...
March 30, 2010 at 5:06 am
Viewing 15 posts - 16 through 30 (of 192 total)