User Marian

113 votes

Accepted

How can I specify the position for a new column in PostgreSQL?

answered Jun 12, 2011 at 14:14

53 votes

Accepted

Passing array parameters to a stored procedure

answered Jan 14, 2011 at 19:59

47 votes

Accepted

Difference between Hash, Merge and Loop join?

answered Jan 27, 2011 at 9:11

46 votes

Accepted

How export a sql server 2008 diagram to PDF filetype?

answered Feb 5, 2013 at 10:37

40 votes

Accepted

The login already has an account under a different user name

answered Feb 22, 2013 at 8:06

32 votes

Accepted

Difference between SQL batch, statement and RPC?

answered Feb 10, 2013 at 14:06

31 votes

Accepted

Save Results as CSV with headers in SSMS

answered Jul 14, 2011 at 14:07

27 votes

Writing select result to a csv file

answered Sep 3, 2012 at 13:29

26 votes

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

answered May 12, 2011 at 20:47

25 votes

What are the main causes of deadlocks and can they be prevented?

answered Jan 14, 2011 at 12:55

22 votes

Accepted

Get Job id OR Job name from within executing job

answered Feb 17, 2012 at 19:41

21 votes

Should developers be able to query production databases?

answered Jan 6, 2012 at 17:14

21 votes

Why is my database still fragmented after I rebuilt and reindexed everything?

answered Sep 5, 2011 at 10:45

16 votes

What are some best practices for using schemas in SQL Server?

answered Jul 25, 2011 at 19:25

15 votes

Accepted

Is there any tangible difference between a unique clustered index and a clustered primary key?

answered Jan 21, 2011 at 18:29

13 votes

Accepted

When should I use Full-Text Search?

answered Mar 23, 2011 at 10:41

13 votes

Accepted

Optimising BCP performance for BLOB data

answered Aug 26, 2011 at 8:40

13 votes

The smallest backup possible ... with SQL Server

answered Jun 2, 2011 at 11:45

12 votes

Accepted

Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?

answered Jan 18, 2011 at 17:06

11 votes

Accepted

Purpose of IDs in a User Table Database

answered May 5, 2011 at 7:11

11 votes

Accepted

How to improve InnoDB DELETE performance?

answered Mar 3, 2011 at 0:39

11 votes

Accepted

SQLCMD command is not able to insert accents

answered Apr 22, 2013 at 7:25

10 votes

Postgres Write Performance on Intel S3700 SSD

answered Jun 25, 2013 at 18:28

10 votes

Accepted

SSIS 2008 Package Configurations being ignored

answered Feb 28, 2013 at 16:14

10 votes

What is the fastest way to export a table to a text file

answered Nov 23, 2012 at 11:57

10 votes

Justify NOT using (nolock) hint in every query

answered May 12, 2011 at 20:11

10 votes

Accepted

Send email when certain Data is being inserted in MS SQL Server

answered Jul 20, 2011 at 8:17

9 votes

Accepted

Are heaps considered an index structure or are they strictly a table structure without index?

answered Aug 15, 2011 at 6:09

9 votes

Why is `SELECT @@IDENTITY` returning a decimal?

answered Aug 16, 2011 at 21:45

9 votes

Accepted

Is it possible to get execution call stack in a trigger?

answered Jul 13, 2011 at 15:01

Stack Exchange Network

279 Answers

How can I specify the position for a new column in PostgreSQL?

Passing array parameters to a stored procedure

Difference between Hash, Merge and Loop join?

How export a sql server 2008 diagram to PDF filetype?

The login already has an account under a different user name

Difference between SQL batch, statement and RPC?

Save Results as CSV with headers in SSMS

Writing select result to a csv file

Sql Server Maintenance Plan - Best Practices on Tasks and Scheduling

What are the main causes of deadlocks and can they be prevented?

Get Job id OR Job name from within executing job

Should developers be able to query production databases?

Why is my database still fragmented after I rebuilt and reindexed everything?

What are some best practices for using schemas in SQL Server?

Is there any tangible difference between a unique clustered index and a clustered primary key?

When should I use Full-Text Search?

Optimising BCP performance for BLOB data

The smallest backup possible ... with SQL Server

Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?

Purpose of IDs in a User Table Database

How to improve InnoDB DELETE performance?

SQLCMD command is not able to insert accents

Postgres Write Performance on Intel S3700 SSD

SSIS 2008 Package Configurations being ignored

What is the fastest way to export a table to a text file

Justify NOT using (nolock) hint in every query

Send email when certain Data is being inserted in MS SQL Server

Are heaps considered an index structure or are they strictly a table structure without index?

Why is `SELECT @@IDENTITY` returning a decimal?

Is it possible to get execution call stack in a trigger?