user avatar
user avatar
user avatar
Zane
  • Member for 9 years, 11 months
  • Last seen more than a month ago
  • Minneapolis, MN
20 votes
Accepted

Why does LEN() function badly underestimate cardinality in SQL Server 2014?

19 votes

Is there any limit to the number of databases you can put on one SQL server?

13 votes

SQL import data when both source and destination has data and identity column

13 votes

How can I determine which tables are causing the database to grow over time?

12 votes

What is the fastest way to insert large numbers of rows?

11 votes
Accepted

Is there any difference between a predicate using a literal value or a parameter value when that value will always be the same?

10 votes
Accepted

Deleting Rows is Increasing Index Size

8 votes

Automatically restore SQL Server database from file from another server

7 votes

How can I avoid repeating the same condition in a "when matched then update" clause?

7 votes
Accepted

Lookup table naming convention?

7 votes
Accepted

Inline Select Causing Incredibly slow query performance

7 votes

"Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio

6 votes

Potential risks of users connecting to SQL Server, through Excel, as sysadmin?

6 votes

Identify why a user can drop a database

6 votes

Why is my log file so massive? 22gb. I am running log backups

5 votes

Is NEWSEQUENTIALID unique within a database for Many tables?

5 votes

Remote queries and linked servers

5 votes
Accepted

Finding changes for table-valued function definition on SQL Server

5 votes
Accepted

Should I rely on Database Engine Tuning Advisor for creating indexes?

4 votes

Dealing with CXPACKET waits - setting cost threshold for parallelism

4 votes

copy/sync only data between 2 database with non identical table structure

4 votes

Does CAST(DateTime AS DATE) cause the entire table to be CAST before comparison?

4 votes

Batch converting indexes to keys

3 votes
Accepted

Getting a "Request to run job refused because the job is already running" When no job is running?

2 votes

Getting last row for each day in MySQL

2 votes

Sql server 2014: backup log to 2 destinations

2 votes

How to pass parameter in select query(In with clause) and not in where condition in SQl Server SSIS Package?

1 vote

Non Clustered Index Scan Properties window - Predicate order different than query order

1 vote

best ETL design to transfer transaction tables records into the data-warehouse

1 vote

Passing values to variables defined in SSIS package at run time