Experts Perspective Webcast: Wait Watchers – Gain Performance Increases Fast
Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...
2014-08-12
621 reads
Following in the footsteps of such greats community leaders as Brent Ozar and Kevin Kline I have the opportunity, nay...
2014-08-12
621 reads
If you want to create sample random samples when dealing with date calculations to test your results, you can easily...
2014-08-12
536 reads
I will be presenting the session “Modern Data Warehousing” tomorrow (Wednesday, August 13th) at the Central New Jersey SQL User...
2014-08-12
648 reads
I just saw this, but you should be aware. There’s a potential Denial of Service/Elevation of Privilege bug in SQL...
2014-08-12
769 reads
Renaming or Changing SQL Server cluster instance process is bit different from renaming a stand-alone instance.
Refer : Rename or Change SQL...
2014-08-12 (first published: 2014-08-04)
16,519 reads
Round():-This function is used to round a numeric field to the number of decimals specified.
Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression...
2014-08-12
891 reads
Common date values you may need to reference that you may not want to write from scratch each time.
Hope...
2014-08-12
1,061 reads
Last week on one of our production servers (version 2011.110.3373.0), we’ve encountered a strange issue which is relatively new (only...
2014-08-12
608 reads
Sum():- This function is used to get the sum of values of the specified numeric column.
Syntax:-
Select Sum (column_name) from tablename
Example:-...
2014-08-12
729 reads
Look at that, it is once again that time of the month that has come to be known as TSQL Tuesday. TSQL Tuesday is a recurring blog party that...
2014-08-12
10 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers