T-SQL Tuesday #57–SQL Family and Community
It’s T-SQL Tuesday time again. After missing two months with my sabbatical, I’m back.
The topic this month is hosted by...
2014-08-12
713 reads
It’s T-SQL Tuesday time again. After missing two months with my sabbatical, I’m back.
The topic this month is hosted by...
2014-08-12
713 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
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
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
This function returns the distinct values from the left query that are not also found on the right query. For...
2014-08-12
786 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
On Saturday, September 13th, I’ll be presenting my 10 Ways To Abuse T-SQL session in Kansas City. If you haven’t...
2014-08-11
295 reads
Error : Database backup is getting fail with below reason. The backup of full-text catalog ‘FullTextCatalog’ is not permitted because it is not online. Check errorlog file for the...
2014-08-11
27 reads
More notes, hopefully not repeating any from previous posts!
Karla has used the chart showing registration growth as a way to...
2014-08-11
568 reads
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2014-08-11
696 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