While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.
2011-03-09
4,423 reads
In a previous blogs, I discussed what shared schedules were and walked you through step by step instructions on how...
2011-03-09
1,154 reads
I rarely use filters in my SSRS reports. However, this was a client requirement. When we attempted to use the...
2011-03-09
2,616 reads
Join this webinar from Pluralsight, a very well known developer training company. Learn how SQL Source Control can help you keep track of your code.
2011-03-08
3,021 reads
SQL Server is able to make implicit use of parallelism to speed SQL queries. Quite how it does it, and how you can be sure that it is doing so, isn't entirely obvious to most of us. Paul White begins a series that makes it all seem simple, starting at the gentle level of counting Jelly Beans.
2011-03-08
4,900 reads
This challenge invites you to write a query that converts binary values into decimal format.
2011-03-07
6,711 reads
When I read various forums about SQL Server, I frequently see questions from deeply mystified posters. They have identified a slow query or stored procedure in their application. They cull the SQL batch from the application and run it in SQL Server Management Studio (SSMS) to analyse it, only to find that the response is instantaneous. At this point they are inclined to think that SQL Server is all about magic. A similar mystery is when a developer has extracted a query in his stored procedure to run it stand-alone only to find that it runs much faster – or much slower – than inside the procedure.
2011-03-07
5,326 reads
Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.
2011-03-04 (first published: 2009-10-14)
150,440 reads
Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a classic of bad database design, an auxiliary table that holds static data, and is used to lookup values, still has powerful magic. Joe Celko explains....
2011-03-04
7,435 reads
The 2011 edition of MVP Jacob Sebastian's T-SQL Quiz is underway. You can take part in the quiz each day, submitting your answers for the chance to show off your knowledge and perhaps win some prizes.
2011-03-04
4,394 reads
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers