Skip to content
Navigation menu
Search
Powered by
Search
Algolia
Log in
Create account
Forem
Close
#
sqlserver
Follow
Hide
Posts
Left menu
👋
Sign in
for the ability to sort posts by
relevant
,
latest
, or
top
.
Right menu
SQL Server Database Partitioning
jeevan wijerathna
jeevan wijerathna
jeevan wijerathna
Follow
Jun 13 '22
SQL Server Database Partitioning
#
sql
#
sqlserver
10
reactions
Comments
Add Comment
4 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 #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 #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
6
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
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)
em8215
em8215
em8215
Follow
Apr 11 '22
The difference in the handling of the spaces between Oracle and SQL Server(In the event of linking different DBMS)
#
sql
#
oracle
#
sqlserver
6
reactions
Comments
Add Comment
4 min read
Install SQL Server command-line tools
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Follow
Apr 26 '22
Install SQL Server command-line tools
#
sql
#
ubuntu
#
sqlserver
#
installation
6
reactions
Comments
Add Comment
1 min read
Install SQL Server in Ubuntu
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Seffu Kioi Nyambura
Follow
Apr 26 '22
Install SQL Server in Ubuntu
#
ubuntu
#
sql
#
installation
#
sqlserver
9
reactions
Comments
Add Comment
1 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
What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.
kakisoft
kakisoft
kakisoft
Follow
Apr 14 '22
What day is one month after 31st January? What day is one month before 31st March? I checked it with various RDBs.
#
rdb
#
mysql
#
postgres
#
sqlserver
6
reactions
Comments
5
comments
5 min read
How to calculate total travel hours between city x and y and vice versa
rajanand ilangovan
rajanand ilangovan
rajanand ilangovan
Follow
Mar 5 '22
How to calculate total travel hours between city x and y and vice versa
#
sqlserver
#
interview
#
questions
2
reactions
Comments
Add Comment
2 min read
Difference of the handling the spaces between Oracle and SQL Server
em8215
em8215
em8215
Follow
Apr 5 '22
Difference of the handling the spaces between Oracle and SQL Server
#
sql
#
oracle
#
sqlserver
5
reactions
Comments
Add Comment
2 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
24
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 #3 - Prepending zeroes
Allan Simonsen
Allan Simonsen
Allan Simonsen
Follow
Mar 8 '22
SQL-Quick tip #3 - Prepending zeroes
#
tsq
#
sqlserver
#
sql
#
mssql
6
reactions
Comments
Add Comment
1 min read
A way to translate sql scripts to a different dialect
taijidude
taijidude
taijidude
Follow
Mar 18 '22
A way to translate sql scripts to a different dialect
#
sql
#
sqlserver
#
hsqldb
#
jooq
2
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
14
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
8
reactions
Comments
Add Comment
1 min read
Get rid of an MS SQL Server database in SingleUserMode
taijidude
taijidude
taijidude
Follow
Feb 23 '22
Get rid of an MS SQL Server database in SingleUserMode
#
sqlserver
#
sql
#
sledgehammersolution
6
reactions
Comments
Add Comment
1 min read
How to generate Permutations in SQL?
rajanand ilangovan
rajanand ilangovan
rajanand ilangovan
Follow
Feb 14 '22
How to generate Permutations in SQL?
#
sql
#
sqlserver
#
interview
5
reactions
Comments
Add Comment
2 min read
loading...
We're a blogging-forward open source social network where we learn from one another
Log in
Create account