Archives: September 2015
I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So updating a simple view is easy enough. Per BOL:
- You can modify the data of an underlying base table through a view, as long as the following…
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it can be kind of hard to remember which connection is which. Fortunately all of the information you need is readily available.
Connections in the Object Explorer
Notice that for each… Read more
I’ve you’ve run a query similar to the following:
SELECT * FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle);
And gotten an error similar to:
Msg 321, Level 15, State 1, Line 9
“sql_handle” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or… Read more
I spent something like 2 hours today trying to figure out how a particular user had access to one of my databases. It’s one of the strangest things I’ve ever seen while playing with SQL Server security. Here’s how it plays out:
You have a windows group called [Kenneth-Laptop\Dwarf] with… Read more
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently used in loops and in error handling.
TL;DR Store @@ROWCOUNT into a variable immediately after the command you are interested in to persist the value for later use.
So why… Read more
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has aggravated me. Telling what services have been installed is pretty easy, discovering if the backwards compatibility components were installed, for example, is a bit more difficult. Well recently I found… Read more
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something out in the process. I typically want to start by determining what the slowest part of the SP is. Normally I use sys.dm_exec_query_stats and run a query something like this: Read more
This T-SQL Tuesday we are hosted by one of the DBA’s of the night: Jen McCown (b/t). She want’s us to talk about Strategies for managing an enterprise. Honestly, had I know she was hosting I probably would have seen this one coming since she and… Read more
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ever looked at much. Well as it happens I had something that I needed to use it on a day or two later and… Read more