Viewing 15 posts - 646 through 660 (of 813 total)
Honestly, I think the #1 takeaway from this thread is:
Name functions with accuracy and specificity!
Microsoft's "IsNumeric" is neither specific, nor accurate (it does _not_ test for strings that must match...
December 2, 2010 at 11:04 am
Kwisatz78 (11/24/2010)
How does a web front end not qualify for a device CAL when all external users will be...
December 1, 2010 at 8:45 am
Keith Langmead (11/30/2010)
By default the tempdb is set as Simple recovery model, so I doubt the tempdb transaction log file would be the cause.
Simple recovery simply means the tempdb...
December 1, 2010 at 8:19 am
wayne-862477 (12/1/2010)
Jeff,...Realistically the best thing to do would be to create validation by type (IsInt, IsDecimal etc) so you also don't run into overflow problems and things like that.
+1; most...
December 1, 2010 at 8:11 am
A) Yes, get a professional in. You'll learn a lot, and have a better setup.
B) For a simplified system, build yourself a table with rather less factors: Change the...
October 13, 2010 at 9:24 am
dan.nutley (8/12/2010)
I don't think it matters very much...the CPU (assuming you've got any Xeon made within the last 5 years) is rarely the bottleneck on such systems.
I agreed with you.......
October 1, 2010 at 1:06 pm
Shared disk may be cheaper, and is absolutely simpler on the SAN side.
Shared disk with non-SQL apps, however, means that you cannot guarantee SLA's on query performance; if some other...
October 1, 2010 at 12:59 pm
When it doubt about a system level change, make a drive image first. I've done this many times, and every once in awhile it's a major lifesaver (we applied...
September 30, 2010 at 12:19 pm
Time it (and use SQL Server Profiler SQL:BatchCompleted statistics on Reads, Writes, CPU, Duration if you can) several ways:
1) The way it is now
2) Dropping/recreating indexes (watch out for ones...
September 29, 2010 at 10:15 am
I regularly restore 100-1000GB SQL Server 2000 database backups to SQL Server 2008 R2 servers without issues; whether the stored procedures all still work, I don't know, however the data...
September 29, 2010 at 10:12 am
I would note that even for developers with a Computer Science degree, while relational theory may be covered (often optionally), actually working with real data is usually not. In...
September 29, 2010 at 10:00 am
Speeding transfer across network by transferring the compressed version:
Use any compression tool in its fastest mode that:
A) writes the initial compressed file directly to the target directory
and
...
September 27, 2010 at 8:13 am
And a Bulk Export to match Bulk Import from straight SQL, using a format file.
More flexible format files would be nice, too.
September 23, 2010 at 2:36 pm
Temporal support for periods and for explicit intervals, with sufficient index capability so as to be able to include periods (start date, end date) in a table, put an index...
September 22, 2010 at 3:29 pm
For Gila's and everyone else's bag of tricks:
To add space to a drive that's out, there are a variety of options.
Temporary:
A) ENTIRELY SAFE: Clear out IE's and any other browser...
September 21, 2010 at 8:30 am
Viewing 15 posts - 646 through 660 (of 813 total)