If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.
2011-08-31
5,236 reads
Continuing the interview with Brad McGehee, Robert Pearl asks about the new features in 2008 and his books.
2009-04-10
1,381 reads
MVP Brad McGehee, director of DBA Education for Red Gate Software, sat down recently with longtime author, Robert Pearl. In this interview, learn a bit about how Brad got started in the SQL Server world.
2009-04-09
3,342 reads
Hi a5xo3z1, I use no tools other than Query Analyser and a small stack of TSQL books from Amazon for the application programming. I agree that the Upsizing Wizard to get the initial data across is the first thing, that takes about a day, then the real work follows. You can copy some Jet Sql […]
2003-08-20
Another way is SELECT CASE WHEN col2 IS NULL THEN col1 ELSE col1+ ', ' +col2 END FROM ....
2003-06-12
1 reads
Try moving the ',' into the ISNULL function. SELECT Col1 + ISNULL(', ' + Col2, '') This way the comma will show up only when you have a non null value in Col2
2003-06-12
1 reads
By Steve Jones
mottleheaded – adj. feeling uneasy when socializing with odd combinations of friend and family,...
By Rob Sewell
In the WordPress community, badges aren’t just for scouts.
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers