adopilot's user avatar
adopilot's user avatar
adopilot's user avatar
adopilot
  • Member for 11 years, 1 month
  • Last seen more than a month ago
41 votes
4 answers
78k views

Table-Valued Parameter as Output parameter for stored procedure

31 votes
4 answers
60k views

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

13 votes
2 answers
6k views

Do SQL Server Express Editions support CLR procedures?

12 votes
4 answers
11k views

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

11 votes
4 answers
6k views

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

11 votes
4 answers
61k views

How to make conditional ordering for two or more columns

8 votes
3 answers
22k views

Sort by match of LIKE

8 votes
2 answers
9k views

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

6 votes
4 answers
10k views

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

6 votes
2 answers
7k views

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

5 votes
2 answers
417 views

How to design index for faster deletes

5 votes
1 answer
13k views

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

4 votes
2 answers
437 views

switch TOP clause between percentage and rows by parameter

4 votes
1 answer
1k views

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

4 votes
2 answers
1k views

Replication between SQL Server 2005 and Azure database

4 votes
1 answer
175 views

Pricing of databases in Azure

3 votes
1 answer
273 views

Mathematical method for spotting irregularity in numbers flow

3 votes
4 answers
549 views

Help improving SQL Server 2005 query execution time

3 votes
1 answer
152 views

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

3 votes
2 answers
1k views

Find top by values by percents using range in SQL Server

3 votes
2 answers
461 views

Unable to BackUp Database on SQL2005

2 votes
3 answers
332 views

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

2 votes
1 answer
3k views

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

2 votes
1 answer
880 views

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

2 votes
1 answer
2k views

How to design database for tree view with an infinite depth

2 votes
3 answers
1k views

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

2 votes
1 answer
175 views

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

2 votes
3 answers
2k views

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

2 votes
1 answer
161 views

MySql column without aggregates and group by clause

2 votes
1 answer
2k views

Find tables with multiple indexes on same column