SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
1,056 reads
SQL and Me
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
288 reads
SQL Server – Different Ways to Check Object Definition
sp_helptext is widely used for checking object definition in SQL Server. sp_helptext can be used to check definition of various...
2014-04-14
118 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-15 (first published: 2014-04-07)
3,298 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
491 reads
SQL Server – Hide system objects in Object Explorer – SQL Server Management Studio
By default, SQL Server system objects are listed in Object Explorer in Management Studio. These system objects include system database,...
2014-04-07
302 reads
SQL Server – How to get last access/update time for a table
Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the...
2014-03-11
7,738 reads
SQL Server – How to get last access/update time for a table
Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the...
2014-03-11
263 reads
SQL Server – How to get last access/update time for a table
Modify date and create date for a table can be retrieved from sys.tables catalog view. When any structural changes are made the...
2014-03-11
157 reads
SQL Server – Displaying line numbers in Query Editor – SSMS
You can enable line numbers to be displayed in SSMS Query Editor. This is extremely useful when working on a...
2014-01-20
927 reads
Blogs
Scooby Dooing Episode 9: The Case of the Artificially Intelligent Villain
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
The Book of Redgate: Don’t be an a**hole
By Steve Jones
This was one of the original values: The facing page has this text: No...
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
I Love Editorials
Comments posted to this topic are about the item I Love Editorials
Line number in error message doesn't match up with line number in code
Hi everyone I have a 1000 plus line query and I am getting an...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers