Skip to main content
marc_s's user avatar
marc_s's user avatar
marc_s's user avatar
marc_s
  • Member for 15 years, 10 months
  • Last seen this week
  • Bern, Switzerland
3474 votes
Accepted

Get size of all tables in database

1054 votes
Accepted

How to run a PowerShell script

800 votes
Accepted

Exporting data In SQL Server as INSERT INTO

751 votes
Accepted

List of all index & index columns in SQL Server DB

704 votes

Validate a username and password against Active Directory?

628 votes
Accepted

What are the best practices for using a GUID as a primary key, specifically regarding performance?

606 votes
Accepted

How do I use an INSERT statement's OUTPUT clause to get the identity value?

604 votes
Accepted

What is the maximum characters for the NVARCHAR(MAX)?

596 votes
Accepted

SQL Data Reader - handling Null column values

588 votes
Accepted

SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints

582 votes

DateTime2 vs DateTime in SQL Server

552 votes
Accepted

SQL Server add auto increment primary key to existing table

543 votes

BasicHttpBinding vs WsHttpBinding vs WebHttpBinding

540 votes

How to store decimal values in SQL Server?

495 votes
Accepted

How to read an entire file to a string using C#?

487 votes

Unique constraint on multiple columns

478 votes

How to generate string of a certain length to insert into a file to meet a file size criteria?

430 votes
Accepted

Does a foreign key automatically create an index?

413 votes

How do I use cascade delete with SQL Server?

403 votes
Accepted

What are the differences between WCF and ASMX web services?

401 votes

When to use DataContract and DataMember attributes?

390 votes
Accepted

SQL DROP TABLE foreign key constraint

373 votes
Accepted

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

369 votes
Accepted

Query to list number of records in each table in a database

363 votes
Accepted

How to change column datatype in SQL Server database without losing data?

338 votes
Accepted

Storing images in SQL Server?

330 votes
Accepted

How to find largest objects in a SQL Server database?

312 votes
Accepted

Get the last inserted row ID (with SQL statement)

310 votes
Accepted

Convert XML String to Object

302 votes
Accepted

Compare DATETIME and DATE ignoring time portion

1
2 3 4 5
315