Home » SSMS (Page 2)
Category Archives: SSMS
Sequence – Long awaited feature
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and may cycle (repeat) as requested. Sequences, unlike identity … Continue reading
Thanks to Toadworld.com team for recognition !
Thanks to Toadworld.com team for recognition ! Toadworld.com Profile : http://www.toadworld.com/members/rohit-garg/blogs/default.aspx If you liked this post, do like on Facebook at http://www.facebook.com/mssqlfun Reference : Rohit Garg (http://mssqlfun.com/)
2013 with You & SQL Server
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 41,000 times in 2013. If it were a concert at Sydney Opera House, it would take about 15 sold-out performances for that many … Continue reading
Refresh Intellisense in SSMS(SQL Server Management Studio) 2008 & above
Intellisense is a new feature that comes with SSMS(SQL Server Management Studio) 2008 onwards. Intellisense makes coding quite easy. But Sometimes I find that intellisense becomes stale and you start getting the wavy red lines when writing code. Even though object exists in database but Intellisense is not able to recognize it. Refreshing the cache … Continue reading
Text information from RPC trace events not displayed in Profiler
In SQL Server 2005 and later, the information in the TextData column captured for the RPC:Starting and RPC:Completed events is also available in the BinaryData column. For performance reasons, it is more efficient to include the BinaryData column and omit the TextData column, when adding these events to the trace. If the BinaryData column is … Continue reading