Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in sql-server
Horizontal to vertical display using Dynamic Pivot Function
Jun 20, 2022
sql
sql-server
pivot
SQL Server : drop column @variable not working
Aug 03, 2019
sql
sql-server
local-variables
Where does SQL Server store deployed CLR Assemblies?
Aug 14, 2022
c#
sql-server
sqlclr
Only run SQL query if condition met
Oct 23, 2022
mysql
sql
sql-server
Client-side vs server-side database transactions
Apr 17, 2022
sql-server
transactions
Set SQL Server Database to only allow ANSI Compliant SQL Code
Oct 17, 2022
sql
sql-server
ansi-sql
Why is "OR operation" or OR condition non-sargable?
Feb 25, 2018
sql
sql-server
Entity Framework gets progressively slow with extra join added even though SQL generated is fast
Oct 30, 2022
c#
sql-server
performance
linq
entity-framework
Auto Increment in update statement resulting in duplicate values on large table
Feb 14, 2022
sql-server
tsql
sql-server-2012
can dacpac be used for managing databases having large volume of data?
May 19, 2022
sql-server
sql-server-2012
dacpac
data-tier-applications
sqlpackage
Type 2 Effective Dated Index Performance with Multiple Dimensions in TSQL
Jun 04, 2022
sql-server
tsql
indexing
Join two tables - One common column with different values
Apr 08, 2022
sql
sql-server
join
sql-server-2000
There was also a ROLLBACK ERROR and tSQLt.ExpectException
Jun 15, 2022
sql
sql-server
unit-testing
tsqlt
Linq to 3 tables with no foreign keys
Mar 01, 2022
sql
sql-server
linq
Cannot swap unique value on two rows with EF
Mar 16, 2022
c#
sql-server
entity-framework
unique-constraint
Azure SQL server max pool size was reached error
Jul 10, 2022
sql-server
azure
azure-sql-database
azure-storage
How to convert multiple rows into one row with multiple columns using Pivot in SQL Server when data having NULL values
Sep 15, 2022
c#
sql
sql-server
pivot-table
Does SqlBulkCopy Enlist in Ambient Transaction?
Jan 30, 2018
c#
sql-server
transactions
transactionscope
Strategies for checking ISNULL on varbinary fields?
Sep 11, 2022
sql
sql-server
performance
binary
varbinary
Backup SQL Schema Only?
Jul 31, 2022
sql
sql-server
oracle
sql-server-2005
backup
« Newer Entries
Older Entries »