“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,305 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,082 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,073 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,016 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,322 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
696 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
I would like to discuss Modvigil 200 mg with you. Honestly, I can't say...
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers