Quarterly Goals
Over time I’ve settled on quarterly goals as the best way to focus on the stuff I most want to...
2014-04-11
526 reads
SQLAndy
Writing My Next Question Of The Day
I ran into a simple error last week and saved it to convert to a question. It’s another one where...
2014-04-07
561 reads
Follow Up To A Questionable Trigger
This question of the day didn’t turn out well at all – required too big a leap the way it was...
2014-04-04
497 reads
SQLServerCentral Editorial: Team Reputation
Maybe too serious a topic for a Friday, I wrote Team Reputation because I like working for good teams – who...
2014-04-04
599 reads
The Untold Story of SQLHotties.com
Back when SQLSaturday was in the #20’s or so I bought SQLHotties.com, thinking it would be good for an April...
2014-04-03
564 reads
PASS Election Season Begins
Saw the announcement in the Connector today that the process of selecting the Nominating Committee (which vets applications for the...
2014-04-02
523 reads
A Questionable Trigger–Question Of the Day
A Questionable Trigger is the SQLServerCentral Question of the Day today. It’s my latest and perhaps the hardest. Here is...
2014-04-02
459 reads
Solid State Tapes–Prelaunch News!
Note: Sorry for the vague details on the tech part, you’ll get all of that tomorrow – this is what I...
2014-04-01
451 reads
Follow Up on The Unusable User–Question Of The Day
I posted about one of my questions of the day called The Unusable User last week and wanted to return...
2014-03-31
1,196 reads
SQLServerCentral Editorial: The Perfect Environment
I write editorials once or twice a month for SQLServerCentral and have fallen out of the habit of mentioning them...
2014-03-28
531 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers