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
448 reads
Blog Posts
DDL Triggers and CREATE_LOGIN/ALTER_LOGIN
I've been doing a lot with DDL triggers in the last week or so and pulling out the relevant information...
2007-07-09
1,149 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
912 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
608 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
644 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
729 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
626 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
783 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
608 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
743 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
Alamat Kantor BCA KCU WISMA ASIA Telp:082144477715
Wa:0821-4447-7715 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers