Article Of the Week
I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way...
2009-08-24
939 reads
SQLDownSouth
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,260 reads
August SQL Server User Group – Near Real-time Data Warehouse
Well we had a really good meeting this week at our User Group. There were about 17 physical attendees and...
2009-08-19
848 reads
Replication – Accommodating Application Inserts
Recently I have been involved in lots of projects involving replication. I have done some things to make replication work...
2009-08-17
1,258 reads
Upgrading To Windows 7
Well I spent most of this past Saturday upgrading my Laptop to Windows 7 Ultimate, which I have to say...
2009-08-13
747 reads
Database is in Transition
One of my clients called saying they were receiving the following error when trying to access a database: "Error 952...
2009-08-12
6,955 reads
LIVE MEETING REMINDER - Baton Rouge SQL Server User Group
Reminder: The Baton Rouge Area SQL Server User Group will be broadcasting its user group via live meeting. If you...
2009-08-12
448 reads
Adding Multiple Columns to a Table With a Single T-SQL Statement
You know, I believe the old saying, “If you don’t use it you will lose it”. Well, I write a...
2009-08-10
80,665 reads
Baton Rouge SQL Saturday – Evaluation Summary
Well I just finished reviewing the evaluations for my presentation, Introduction to SQL Profiler, which I gave at the Baton...
2009-08-07
476 reads
Use SQL Compare by Red Gate to Find a Missing Index
A couple of weeks ago one of our developers sent me an email saying, “I have a query that returns...
2009-08-07
4,302 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