“That little green arrow.” or “My code used to work but now I’m getting a debug error.”
If you’ve worked with SSMS for any length of time this will look awfully familiar:
SSMS 2008R2
SSMS 2012 +
This little green...
2015-10-15
512 reads
If you’ve worked with SSMS for any length of time this will look awfully familiar:
SSMS 2008R2
SSMS 2012 +
This little green...
2015-10-15
512 reads
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you...
2015-10-15 (first published: 2015-10-07)
2,266 reads
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...
2015-10-13
494 reads
I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...
2015-10-12 (first published: 2015-09-30)
3,081 reads
If you work with a number of different instances and have lots of connections open in Management Studio (SSMS) it...
2015-10-05 (first published: 2015-09-28)
2,069 reads
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...
2015-10-05
527 reads
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...
2015-09-23
1,014 reads
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,258 reads
I spent something like 2 hours today trying to figure out how a particular user had access to one of...
2015-09-21
627 reads
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
695 reads
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Can anyone recommend an Azure SQL Managed Instance book? I'm looking for information about...
hi we run 2019 std but i'm testing this on 2016. following some old...
If you run this code it creates a 2 row cursor loop. Within the...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers