User adopilot

adopilot

Member for 12 years, 8 months
Last seen this week

Twitter
GitHub
robotsarajevo.com
Sarajevo, Federacija Bosne i Hercegovine, Bosna i Hercegovina

44 Questions

Score Activity Newest Views

43 votes

4 answers

87k views

Table-Valued Parameter as Output parameter for stored procedure

asked Feb 23, 2012 at 16:34

32 votes

4 answers

68k 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

12k 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

68k 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

23k views

Sort by match of LIKE

asked Dec 4, 2011 at 19:48

8 votes

2 answers

10k 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

429 views

How to design index for faster deletes

asked Jul 4, 2013 at 9:00

5 votes

1 answer

13k views

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

asked Aug 26, 2011 at 14:21

4 votes

2 answers

449 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

183 views

Pricing of databases in Azure

asked Feb 14, 2013 at 15:00

3 votes

1 answer

274 views

Mathematical method for spotting irregularity in numbers flow

asked Aug 12, 2013 at 16:38

3 votes

4 answers

562 views

Help improving SQL Server 2005 query execution time

asked Nov 7, 2009 at 16:38

3 votes

1 answer

161 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

470 views

Unable to BackUp Database on SQL2005

asked Sep 17, 2011 at 13:31

2 votes

3 answers

351 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

179 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

181 views

MySql column without aggregates and group by clause

asked May 12, 2017 at 18:08

2 Next