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,050 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
284 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
114 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,290 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
484 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
297 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,733 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
260 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
154 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
922 reads
Blogs
Drop roles in Postgres
You can’t just exec DROP ROLE your_role_name; if it’s granted perms or other roles...
Get a PAT in Azure DevOps
By Steve Jones
I have a presentation recently on Continuous Integration Using Local Agents in Azure DevOps...
The Local OLLAMA Gui
By Steve Jones
I ran a small ollama model in a container and have been doing some...
Forums
Why you should avoid Implicit Measures in your Power BI model
Comments posted to this topic are about the item Why you should avoid Implicit...
Calculating Numerator and Denominator
Good evening, I have a rather peculiar issue while trying to calculate Numerator and...
Select statement with in using multiple columns
I inherited a mess. The previous developer did not understand how to set up...
Question of the Day
The AG Synchronous Replicas
In a SQL Server 2022 Enterprise Edition AG, how many replicas can be configured with synchronous commit mode?
See possible answers