Home » SQL Server Management Studio (Page 2)
Category Archives: SQL Server Management Studio
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
Creation & Deletion of Database Snapshot by SQL Agent Job
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be done very easily. So let’s … 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