sql statements | SQL Studies

Tag Archives: sql statements

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.
7
April 30, 2014 by Kenneth Fisher

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
The default autogrowth settings do NOT come from the Model database.
5
April 28, 2014 by Kenneth Fisher

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, SSMS, System Databases, System Functions and Stored Procedures, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, SSMS, system databases, system functions, T-SQL
Collation: Temporary objects and variables: Demonstration
4
April 21, 2014 by Kenneth Fisher

I had a recent run in with collation problems and it got me started reading about them. As I read …
Continue reading

Category: Collation, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, collation, language sql, microsoft sql server, sql statements, system functions, T-SQL
Default nullability of a new column
Leave a comment
March 31, 2014 by Kenneth Fisher

Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? …
Continue reading

Category: Microsoft SQL Server, Settings, SQLServerPedia Syndication, T-SQL | Tags: code language, default settings, language sql, sql statements, T-SQL
Characters you should never ever use in an object or schema name!
Leave a comment
March 5, 2014 by Kenneth Fisher

You can put pretty much any character you want into an object or schema name by enclosing the name in …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL
Impersonating a server level permission
12
February 26, 2014 by Kenneth Fisher

Warnings up front, this has some serious security implications. The method I’m going to use minimizes that somewhat but it’s …
Continue reading

Category: Impersonation, Microsoft SQL Server, Security, SQLServerPedia Syndication, T-SQL | Tags: code language, database permissions, Impersonation, language sql, microsoft sql server, security, server permissions, sql statements, T-SQL
Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.
2
January 29, 2014 by Kenneth Fisher

I frequently rely on joining sys.dm_exec_requests and sys.dm_exec_sql_text() to know what queries are running on a system and when I …
Continue reading

Category: DMV, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL, Transactions | Tags: code language, DMV, language sql, microsoft sql server, sql statements, T-SQL
Negative session_ids
3
January 27, 2014 by Kenneth Fisher

I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
Continue reading

Category: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL, Transactions | Tags: code language, DMV, language sql, microsoft sql server, problem resolution, sql statements, system functions, T-SQL, transactions
The “most_recent_sql_handle” column
1
January 22, 2014 by Kenneth Fisher

While researching my last post I ran across an interesting column I hadn’t noticed before, sys.dm_exec_connections.most_recent_sql_handle. I mentioned it in …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: code language, DMV, language sql, microsoft sql server, sql statements, system functions, T-SQL
Guid vs Identity columns (Ints)
11
January 13, 2014 by Kenneth Fisher

I came across an interesting question on SE last week. Guid vs INT – Which is better as a primary …
Continue reading

Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: code language, language sql, microsoft sql server, sql statements, T-SQL

« Older Entries

Newer Entries »

SQL Studies

Tag Archives: sql statements

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

The default autogrowth settings do NOT come from the Model database.

Collation: Temporary objects and variables: Demonstration

Default nullability of a new column

Characters you should never ever use in an object or schema name!

Impersonating a server level permission

Using sys.dm_exec_sql_text() to figure out blocking is sometimes flawed.

Negative session_ids

The “most_recent_sql_handle” column

Guid vs Identity columns (Ints)

Follow me via RSS

Follow me via Email

Follow me on Twitter

Archives

Categories

Meta