T-SQL | SQL Studies

Tag Archives: T-SQL

EXECUTE, not required, but advisable.
1
February 6, 2013 by Kenneth Fisher

The other day one of the developers I work with gave me a script similar to this: He was getting …
Continue reading

Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, problem resolution, sql statements, T-SQL
Duplicate rows in a table
19
February 4, 2013 by Kenneth Fisher

I recently got the following email: “I just keyed in two rows into a table with all identical column values. …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL, TOP
Small changes, big effects
Leave a comment
January 30, 2013 by Kenneth Fisher

We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
Continue reading

Category: Index, Microsoft SQL Server, Performance, Problem Resolution, SQLServerPedia Syndication, T-SQL | Tags: code language, index, language sql, microsoft sql server, sql statements, T-SQL
IsMSShipped
3
January 23, 2013 by Kenneth Fisher

I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t …
Continue reading

Category: Keywords, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, object functions, object id, property functions, sql statements, system functions, T-SQL
My view isn’t reflecting changes I’ve made to the underlying tables.
8
January 20, 2013 by Kenneth Fisher

Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change. …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, system functions, T-SQL
How I like to learn a t-sql command
11
January 7, 2013 by Kenneth Fisher

Recently I received a security request and realized I wasn’t comfortable in my ability to script out the t-sql commands …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, SSMS, T-SQL | Tags: code language, language sql, microsoft sql server, script button, sql statements, SSMS, T-SQL
Red errors in the results pane
3
December 19, 2012 by Kenneth Fisher

Most DBAs have seen those nice clear red errors in the results pane. And I’m sure most DBAs have noticed …
Continue reading

Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, SSMS, T-SQL | Tags: code language, language sql, microsoft sql server, problem resolution, SSMS, T-SQL
Generating multiple SQL statements from a query
2
December 17, 2012 by Kenneth Fisher

Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
Continue reading

Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, dynamic sql, language sql, microsoft sql server, sql statements, T-SQL
Where is my backup?
10
December 12, 2012 by Kenneth Fisher

We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working …
Continue reading

Category: Backups, Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: backups, code language, microsoft sql server, msdb database, system functions, T-SQL
Creating an empty table from a SELECT statement
12
November 26, 2012 by Kenneth Fisher

I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W. …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, Ian W. Stirk, language sql, microsoft sql server, T-SQL

« Older Entries

Newer Entries »

SQL Studies

Tag Archives: T-SQL

EXECUTE, not required, but advisable.

Duplicate rows in a table

Small changes, big effects

IsMSShipped

My view isn’t reflecting changes I’ve made to the underlying tables.

How I like to learn a t-sql command

Red errors in the results pane

Generating multiple SQL statements from a query

Where is my backup?

Creating an empty table from a SELECT statement

Follow me via RSS

Follow me via Email

Follow me on Twitter

Archives

Categories

Meta