New posts in sql-server

Script to import data from Excel file to SQL Server but the problem is it creates new data

Insert multiple rows from a date range

Modify Group By to achieve correct results

MSSQL 2008 R2 server roles: do server roles have implicit privileges over *all databases*?

The conversion of a date data type to a datetime data type resulted in an out-of-range value

Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?

How to find out what is locking my tables?

How to Identify port number of SQL server

What is the purpose of PAD_INDEX in this SQL Server constraint?

Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration

Calculate rank based on Consecutive Dates (Return to 1 if there is a gap days between dates)

Using SQL Server as a DB queue with multiple clients

How to make CREATE OR REPLACE VIEW work in SQL Server? [duplicate]

SQL - How do I get only the numbers after the decimal?

EF Exception: String or binary data would be truncated. The statement has been terminated.?

Restore SQL Server DB without transaction log

MS Sql Server getting overloading with 'Suspended' queries, mostly reads. Any way to fix this?

How export database from mssql by using command line

Convert JSON value in SQL table to multiple columns

SQL Server 2005 Express: Where is the Profiler?