sql-server Archives - Page 5 of 39

Programming, sql

IT Nursery

How important is the order of columns in indexes?

I’ve heard that you should put columns that will be the most selective at the beginning of the index declaration. Example: CREATE NONCLUSTERED ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server database backup restore on lower version

How to restore a higher version SQL Server database backup file onto a lower version SQL Server? Using SQL Server 2008 R2 (10.50.1600), ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Can you create nested WITH clauses for Common Table Expressions?

WITH y AS ( WITH x AS ( SELECT * FROM MyTable ) SELECT * FROM x ) SELECT * FROM y Does ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

Using varchar(MAX) vs TEXT on SQL Server

I just read that the VARCHAR(MAX) datatype (which can store close to 2GB of char data) is the recommended replacement for the TEXT ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Effect of NOLOCK hint in SELECT statements

I guess the real question is: If I don’t care about dirty reads, will adding the with (NOLOCK) hint to a SELECT statement ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

The object ‘DF__’ is dependent on column ‘’ – Changing int to double

Basically I got a table in my EF database with the following properties: public int Id { get; set; } public string Title ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server String or binary data would be truncated

I am involved in a data migration project. I am getting the following error when I try to insert data from one table ...

May 30, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server: Filter output of sp_who2

Under SQL Server, is there an easy way to filter the output of sp_who2? Say I wanted to just show rows for a ...

May 30, 2022
0 Comments

Programming, sql

IT Nursery

Difference between a User and a Login in SQL Server

I have recently been running into many different areas of SQL Server that I normally don’t mess with. One of them that has ...

May 30, 2022
0 Comments

C#, Programming

IT Nursery

What size do you use for varchar(MAX) in your parameter declaration?

I normally set my column size when creating a parameter in ADO.NET. But what size do I use if the column is of ...

May 29, 2022
0 Comments