Add-In for searching object in SSMS without touching mouse
I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and...
2011-11-07
1,007 reads
I was using various “quick find” SSMS add-ins which give you ability to get your tables, stored procedures, functions and...
2011-11-07
1,007 reads
Hi,
new, second version of SQL Treeo productivity add-in was released.
For little reminder, here are main features of this add-in:
Create...
2011-11-06
2,411 reads
SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...
2011-09-14
730 reads
SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and...
2011-09-08
1,684 reads
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
637 reads
Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm...
2011-08-29
833 reads
Writing data from within user-defined function is not permitted. You cannot use any INSERT/UPDATE/DELETE/MERGE statement because they’re “side-effecting” for SQL...
2011-08-28
1,221 reads
SQL Server 2011 “Denali” is quite rich for new functions which have really good practical use in T-SQL. I’ve read...
2011-08-14
648 reads
I’ve just finished promised SSMS add-in which enables creating of custom folders directly in SSMS Object Explorer. Idea for add-in...
2011-08-08
3,091 reads
SQL Server 2011 “Denali” introduces couple of new procedures which enable you to read query metadata without executing it. Previous...
2011-08-03
1,010 reads
I wanted to figure out how big (or approximately how big) my dump file...
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have a table. Structure in script below. I have to compare and see...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers