Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Search
Log in
Create account
DEV Community
Close
#
tsql
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
SQL Server Management Studio (SSMS)
Ajeet
Ajeet
Ajeet
Follow
Feb 19
SQL Server Management Studio (SSMS)
#
sql
#
sqlserver
#
tsql
#
ssms
1
reaction
Comments
Add Comment
5 min read
SQL Server 2022 - GENERATE_SERIES
Slava Rozhnev
Slava Rozhnev
Slava Rozhnev
Follow
Feb 24 '23
SQL Server 2022 - GENERATE_SERIES
#
sql
#
tsql
#
tutorial
4
reactions
Comments
Add Comment
2 min read
SQL Server 2022: Logical Functions - GREATEST & LEAST
Slava Rozhnev
Slava Rozhnev
Slava Rozhnev
Follow
Dec 9 '22
SQL Server 2022: Logical Functions - GREATEST & LEAST
#
sql
#
tsql
#
tutorial
2
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #15 - Random dates
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 31 '22
SQL-Quick tip #15 - Random dates
#
tsql
#
sqlserver
#
sql
#
mssql
7
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #13 - Index usage
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 17 '22
SQL-Quick tip #13 - Index usage
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #14 - Server information
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 24 '22
SQL-Quick tip #14 - Server information
#
tsql
#
sqlserver
#
sql
#
mssql
9
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #8 - Finding foreign key constraints
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 12 '22
SQL-Quick tip #8 - Finding foreign key constraints
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #12 - Available disk space
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 10 '22
SQL-Quick tip #12 - Available disk space
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #10 - Select table definition
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 26 '22
SQL-Quick tip #10 - Select table definition
#
tsql
#
sqlserver
#
sql
#
mssq
7
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #11 - Most intensive queries
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
May 3 '22
SQL-Quick tip #11 - Most intensive queries
#
tsql
#
sqlserver
#
sql
#
mssql
10
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #9 - Number of rows in all tables
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 19 '22
SQL-Quick tip #9 - Number of rows in all tables
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #7 - Find stored procedures
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Apr 5 '22
SQL-Quick tip #7 - Find stored procedures
#
tsql
#
sqlserver
#
sql
#
mssql
10
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #6 - Find table or column
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 29 '22
SQL-Quick tip #6 - Find table or column
#
tsql
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
2 min read
SQL-Quick tip #5 - Create a sequence of date and time
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 22 '22
SQL-Quick tip #5 - Create a sequence of date and time
#
tsql
#
sqlserver
#
sql
#
mssql
14
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #2 - Randomize rows
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 1 '22
SQL-Quick tip #2 - Randomize rows
#
tsql
#
sqlserver
#
sql
#
mssql
5
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #4 - Random Int for each row
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 15 '22
SQL-Quick tip #4 - Random Int for each row
#
tsql
#
sqlserver
#
sql
#
mssql
13
reactions
Comments
Add Comment
1 min read
SQL-Quick tip #1 - Range of Int
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Feb 25 '22
SQL-Quick tip #1 - Range of Int
#
tsql
#
sqlserver
#
sql
#
mssql
7
reactions
Comments
Add Comment
1 min read
SQL Server Primary Keys
Jin Vincent Necesario
Jin Vincent Necesario
Jin Vincent Necesario
Follow
Jan 22 '22
SQL Server Primary Keys
#
sql
#
tsql
#
primarykey
#
mssql
7
reactions
Comments
1
comment
6 min read
Calculating length of ntext data type with T-SQL
Ferhat Karataş
Ferhat Karataş
Ferhat Karataş
Follow
Dec 15 '21
Calculating length of ntext data type with T-SQL
#
tsql
#
query
#
mssql
5
reactions
Comments
Add Comment
1 min read
How to prevent duplicate count value for inner join
Ferhat Karataş
Ferhat Karataş
Ferhat Karataş
Follow
Oct 28 '21
How to prevent duplicate count value for inner join
#
tsql
#
query
#
mssql
5
reactions
Comments
Add Comment
1 min read
Geohash Open-Source library in TSQL for SQL Server
Jim O'Flaherty
Jim O'Flaherty
Jim O'Flaherty
Follow
Mar 8 '21
Geohash Open-Source library in TSQL for SQL Server
#
sqlserver
#
tsql
#
geohash
#
location
4
reactions
Comments
Add Comment
1 min read
How to monitor backup and restore progress in SQL Server
Alexey Ryazhskikh
Alexey Ryazhskikh
Alexey Ryazhskikh
Follow
Feb 19 '21
How to monitor backup and restore progress in SQL Server
#
sql
#
mssql
#
database
#
tsql
5
reactions
Comments
Add Comment
2 min read
SQL Query Inner Join for SUM Amount
qfjr
qfjr
qfjr
Follow
Oct 26 '20
SQL Query Inner Join for SUM Amount
#
help
#
sql
#
tsql
6
reactions
Comments
1
comment
3 min read
French Amortization Method (PRICE) with T-SQL.
Allan Rodrigues
Allan Rodrigues
Allan Rodrigues
Follow
May 29 '20
French Amortization Method (PRICE) with T-SQL.
#
sql
#
tsql
#
price
5
reactions
Comments
Add Comment
1 min read
Changing a column from int to bigint, without downtime
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Changing a column from int to bigint, without downtime
#
datacompression
#
performance
#
tsql
#
sqlserver
5
reactions
Comments
Add Comment
9 min read
Blocking with OBJECT_NAME()
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
Jan 1 '20
Blocking with OBJECT_NAME()
#
tsql
#
sql
#
sqlserver
5
reactions
Comments
1
comment
4 min read
Coding Abomination: Conway's Game of Life in TSQL
Barrett Otte
Barrett Otte
Barrett Otte
Follow
Sep 22 '19
Coding Abomination: Conway's Game of Life in TSQL
#
tsql
#
sql
#
python
#
gameoflife
5
reactions
Comments
1
comment
3 min read
Find the SQL Server service account with sys.dm_server_services
Andy Mallon
Andy Mallon
Andy Mallon
Follow
for
AM2.co
May 18 '20
Find the SQL Server service account with sys.dm_server_services
#
sql
#
sqlserver
#
database
#
tsql
4
reactions
Comments
Add Comment
2 min read
loading...
We're a place where coders share, stay up-to-date and grow their careers.
Log in
Create account