CTEs and where have I been?
I haven't posted much lately, but it has been a busy few months with many family activities. At work, I...
2007-07-09
450 reads
Wiki For Books Online
Browsing MSDN this morning and saw the note that they now have Wiki support. If done well it could be...
2007-07-09
609 reads
The Perils of NewID for Randomizing Results
NewID() is commonly used in the order by to return the result set in random fashion. No idea whether its...
2007-07-09
920 reads
Service Packs and Support
More coming next week in editorials and already a note on the site, but support for both SQL Server 2000...
2007-07-07
645 reads
Latest Service Packs and Books Online
I was reading a new post at SQL Server Magazine titled The More Things Change(full version available to registered users...
2007-07-06
627 reads
The Video World
I wonder what you think of this: video shorts. I've gottne the Lockergnome newsletters for years and they've proven interesting...
2007-07-06
610 reads
Midlands PASS Chapter July Meeting with SQL Server MVP Wayne Snyder
SQL Server MVP Wayne Snyder Speaks on SQL Server Integration Services (SSIS)
Midlands PASS Chapter - July 12, 2007 Meeting
Sponsored by...
2007-07-06
784 reads
Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
732 reads
Blogs
One of the suggestions I saw today was to add blogs to the user profile on the site and not...
2007-07-05
658 reads
70-444 Exam Prep Book
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
745 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU SEMARANG Tlp:08218154374
WA CS 628218154374 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah...
Alamat Kantor BCA KCU CIREBON Tlp:08218154374
WA CS 628218154374 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat...
Alamat Kantor BCA KCU CIKARANG Tlp:08218154374
WA CS 628218154374 Madison Square, Business Park Lippo Cikarang, Jl. MH. Thamrin No.163, Cibatu,...
Question of the Day
Database Mail Configuration
If I want to get a list of the configuration settings for Database Mail using T-SQL, how can I do so?
See possible answers