Database Administrators
McNets's user avatar
McNets's user avatar
McNets's user avatar
McNets
  • Member for 7 years
  • Last seen more than a week ago
Profile Activity

17 Questions

Score Activity Newest Views
20 votes
2 answers
6k views

DEFAULT CONSTRAINT, worth it?

17 votes
1 answer
7k views

Why COALESCE within a subquery returns NULL?

12 votes
5 answers
3k views

Is there any (hidden) built-in function on MS-SQL to unquote object names?

11 votes
3 answers
902 views

Why would optimiser choose Clustered Index + Sort instead of Non-Clustered Index?

10 votes
1 answer
576 views

Why shouldn't INFORMATION_SCHEMA views be used to determine the schema of an object?

10 votes
1 answer
28k views

Select pairs (a,b) excluding (b,a) with same value

9 votes
2 answers
26k views

Can I get a tree-structure from a self-referenced (hierarchical) table?

7 votes
2 answers
174 views

Updating open orders from a price list within a range of dates

7 votes
4 answers
10k views

Error converting VARCHAR(MAX) to XML due to "UTF-8" attribute

5 votes
1 answer
9k views

Order the result of a comma separated string generated with STUFF

5 votes
1 answer
3k views

SQL Server 2005 - Best way to constraint a Datetime field as Date

5 votes
1 answer
1k views

Is there a way to use sysconv() built-in function?

4 votes
1 answer
6k views

Querying XML nested nodes

4 votes
2 answers
1k views

Permissions using a TYPE as a Table Valued Parameter

3 votes
1 answer
2k views

Error publishing SQLCLR C# Function using Visual Studio 2017

3 votes
1 answer
9k views

SQL Server service permissions on network share depending on IntegratedSecurity=true/false

1 vote
1 answer
1k views

How to get last level of a hierarchical list, group by some field

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.