Reminder – SQLSaturday #38 in Jacksonville Tomorrow
It’s the third time for Jacksonville, hosting SQLSaturday #38 tomorrow at the University of North Florida. It’s about an hour...
2010-05-07
288 reads
Blog Posts
SET clause in SQL Server (2008/2005)
SET clause in SQL Server uses in combination with other clauses to change the current behavior of the SQL Server...
2010-05-07
5,433 reads
SQL Server 2008 Performance Tuning Webcast
I recently gave a presentation on SQL Server Performance Tuning via Live Meeting. I discussed how you could use the...
2010-05-07
1,056 reads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads
Lately I’ve noticed an increasing number of people recommend increasing...
2010-05-07
6,250 reads
Why I Don't Look for a Telecommuting Job
I just got done reading Brent Ozar's post about why folks don't get the telecommuting job they want. It's a...
2010-05-07
3,112 reads
Book Review: The Checklist Manifesto
I saw The Checklist Manifesto by Atul Gawande ($15 @ Amazon) at the bookstore and had to read it. I’ve used...
2010-05-06
1,343 reads
Daily SQL Server 2008 New Feature
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-06
577 reads
Internal Marketing
I heard this recently at my company. Our group, which is relatively removed from the main business of writing software,...
2010-05-06
747 reads
May OPASS Meeting Tonight
Join us tonight for our May OPASS meeting at the SQL Share Offices 225 S. Westmonte Drive, Suite 2010, Altamonte...
2010-05-06
388 reads
Performance Tunning -Checklist
continue with performace tunning stuff, I would like to make a checklist (kind of) for general performance tunning or dba...
2010-05-06
1,124 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers