User adopilot

43 votes

4 answers

89k views

Table-Valued Parameter as Output parameter for stored procedure

asked Feb 23, 2012 at 16:34

33 votes

4 answers

70k views

What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?

asked Nov 17, 2011 at 14:35

15 votes

4 answers

13k views

How to escape '%' inside varchar @params for RAISERROR funcion in SQL Server 2012

asked Aug 18, 2014 at 9:45

13 votes

2 answers

6k views

Do SQL Server Express Editions support CLR procedures?

asked Jan 24, 2012 at 14:41

12 votes

4 answers

69k views

How to make conditional ordering for two or more columns

asked Oct 27, 2011 at 8:55

11 votes

4 answers

6k views

Help me choose a RAID level combination for a SQL Server 2008 instance

asked Nov 11, 2011 at 15:54

8 votes

3 answers

24k views

Sort by match of LIKE

asked Dec 4, 2011 at 19:48

8 votes

2 answers

11k views

SQL Server : how to create user with access only from specific HOSTNAME or IP addres

asked Dec 3, 2014 at 17:16

6 votes

4 answers

11k views

Best pratice to store dates group by months-year key par value

asked Mar 12, 2012 at 8:23

6 votes

2 answers

8k views

Is there a difference in performance between @date and getdate()?

asked May 7, 2013 at 7:18

5 votes

2 answers

438 views

How to design index for faster deletes

asked Jul 4, 2013 at 9:00

5 votes

1 answer

14k views

What I can do to speed up Key Lookup in my Query

asked Aug 26, 2011 at 14:21

4 votes

2 answers

450 views

switch TOP clause between percentage and rows by parameter

asked Oct 27, 2011 at 20:29

4 votes

1 answer

1k views

Restrict record to be update or deleted according to dates inside row for SQL Server 2005

asked Nov 13, 2012 at 15:32

4 votes

2 answers

1k views

Replication between SQL Server 2005 and Azure database

asked Feb 12, 2013 at 23:29

4 votes

1 answer

185 views

Pricing of databases in Azure

asked Feb 14, 2013 at 15:00

3 votes

1 answer

275 views

Mathematical method for spotting irregularity in numbers flow

asked Aug 12, 2013 at 16:38

3 votes

4 answers

565 views

Help improving SQL Server 2005 query execution time

asked Nov 7, 2009 at 16:38

3 votes

1 answer

166 views

Should I change my old datetime columns from SQL Server 2005 to just date datatype for SQL Server 2012

asked Jun 17, 2014 at 10:21

3 votes

2 answers

1k views

Find top by values by percents using range in SQL Server

asked Jan 16, 2013 at 14:12

3 votes

2 answers

472 views

Unable to BackUp Database on SQL2005

asked Sep 17, 2011 at 13:31

2 votes

3 answers

353 views

How to validate and upgrade my knowledge of SQL Server with MCSA [closed]

asked Oct 13, 2011 at 16:17

2 votes

1 answer

3k views

How to move data from Primary Data File to other data file without destroying replication

asked Dec 12, 2011 at 9:50

2 votes

1 answer

1k views

How to add another table to publisher and subscriber without reinitializing the subscriber?

asked Aug 5, 2011 at 14:34

2 votes

1 answer

2k views

How to design database for tree view with an infinite depth

asked May 6, 2012 at 23:11

2 votes

1 answer

6k views

Find last (max) value according to TimeStamp using update method

asked May 8, 2012 at 16:32

2 votes

3 answers

1k views

Help me to map Column types betwenn SQL and TopSpeed Clarion Tables

asked Sep 12, 2013 at 15:13

2 votes

1 answer

180 views

Are there differences in performance of getting data between FullText Search and indexed columns

asked Feb 19, 2013 at 22:34

2 votes

3 answers

2k views

Will performance be better if I specify a filter multiple times?

asked Jun 10, 2013 at 12:13

2 votes

1 answer

183 views

MySql column without aggregates and group by clause

asked May 12, 2017 at 18:08

Stack Exchange Network

44 Questions

Table-Valued Parameter as Output parameter for stored procedure

What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?

How to escape '%' inside varchar @params for RAISERROR funcion in SQL Server 2012

Do SQL Server Express Editions support CLR procedures?

How to make conditional ordering for two or more columns

Help me choose a RAID level combination for a SQL Server 2008 instance

Sort by match of LIKE

SQL Server : how to create user with access only from specific HOSTNAME or IP addres

Best pratice to store dates group by months-year key par value

Is there a difference in performance between @date and getdate()?

How to design index for faster deletes

What I can do to speed up Key Lookup in my Query

switch TOP clause between percentage and rows by parameter

Restrict record to be update or deleted according to dates inside row for SQL Server 2005

Replication between SQL Server 2005 and Azure database

Pricing of databases in Azure

Mathematical method for spotting irregularity in numbers flow

Help improving SQL Server 2005 query execution time

Should I change my old datetime columns from SQL Server 2005 to just date datatype for SQL Server 2012

Find top by values by percents using range in SQL Server

Unable to BackUp Database on SQL2005

How to validate and upgrade my knowledge of SQL Server with MCSA [closed]

How to move data from Primary Data File to other data file without destroying replication

How to add another table to publisher and subscriber without reinitializing the subscriber?

How to design database for tree view with an infinite depth

Find last (max) value according to TimeStamp using update method

Help me to map Column types betwenn SQL and TopSpeed Clarion Tables

Are there differences in performance of getting data between FullText Search and indexed columns

Will performance be better if I specify a filter multiple times?

MySql column without aggregates and group by clause