Using IIF in Reporting Services
I found an interesting use for the IIF function in a Reporting Services report this week. I needed to provide...
2007-03-10
1,710 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
SQL Server Learning Opportunities!
There are two big SQL Server learning opportunities I want to remind you about. First, DevTeach/SQLTeach will be held in...
2007-03-09
1,796 reads
Technology: Where have all the women gone?
Longtime author Kathi Kellenberger brings us a guest editorial today on what is happening with women in the technology world.
2007-02-12
149 reads
Phone books and Indexes
On Wednesday I gave a presentation to the St. Louis Visual Basic.Net user group. I really enjoy speaking to this...
2006-12-22
1,381 reads
SET QUOTED_IDENTIFIER
We recently received a script for a modified stored proc from a vendor. My colleague ran the script on the...
2006-12-15
2,449 reads
The Moto Q and Being Proactive
I am a big fan of automating whatever I can and being proactive. The more proactive you can be, the...
2006-12-14
1,503 reads
Joining Tables Part 1
In this video for beginners you'll begin to learn how to write queries that use more than one table using T-SQL. Kathi walks you through common tactics to efficiently pull out data from a normalized system.
2006-12-11
972 reads
Inserting missing rows
I can think of three ways to insert just the missing rows from one table or query into another table. ...
2006-12-06
2,561 reads
Bad weather and Power Outage
After years of mild weather in the St. Louis area, this is the second time we have been hit hard...
2006-12-02
1,325 reads
Data Dude
I went to an abbreviated version of the Visual Studio 2005 Team Edition for Database Professionals launch this morning. The...
2006-11-30
1,575 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers