Reputation
101,705
Next tag badge:
131/100 score
15/20 answers
Badges
11 171 294
Newest
 Announcer
Impact
~4.8m people reached

8h
comment Integer ID vs varchar ID with JOIN
Don't be afraid of joins or assume that they'll be inefficient. This is what we have indexes for.
15h
revised Index Allocation Maps
added 41 characters in body
15h
answered Index Allocation Maps
15h
comment Index Allocation Maps
Thanks @ypercube, sorry, edited on mobile, didn't even notice the missing tags.
16h
comment Assign a unique count to each row in the resulting table of a select statement
And if you return more than one author, OVER (PARTITION BY AuthorID ORDER BY ID).
17h
revised Index Allocation Maps
deleted 10 characters in body
20h
comment TempDB contentions
What was the initial size of the data files before? What is it now? Are they identical? Are the autogrow settings identical? Have they grown since the last restart? Why do you think you need 16 files? Are you using TF 1117/1118? How many cores on this server? Is it virtualized? Are all the data files on the same underlying volume? What type of disk is it? Have you isolated the main abusers of tempdb?
1d
revised Logon Trigger preventing any connection
added 8 characters in body; edited title
1d
comment SQL Server 2008 R2: Could not connect to TCP error code 10061
Because you get the same error even if the SQL Server service is not running. Did you search? One of my first hits was this. Note that the other instances are running on different ports, did you try to telnet to port 2410? What happened?
1d
comment SQL Server 2008 R2: Could not connect to TCP error code 10061
Sounds like a networking / firewall problem, not a database problem.
1d
comment Setting READ UNCOMMITTED when reading DMVs
@MartinSmith it took a while, but I did eventually blog about how many of the metadata functions ignore isolation level. I've tried to clean up a lot of my code, but anything new I've developed since then prefers joins rather than built-ins like OBJECT_ID(), SCHEMA_NAME(), etc.
1d
comment T-SQL Window over Window?
I also encourage you to read this post - it is centered around badgering people to explain their down-votes, but a lot of educational material in there about why down-votes happen, why you won't always be able to explain them, and why they're much less of a big deal than new users tend to think. The down-vote is a strong mechanism to suggest that the post needs fixing - not a punishment for not fixing it.
1d
comment T-SQL Window over Window?
When you are new to a community, you should read up on etiquette and the help center before posting. Also, down-votes are not permanent; if you edit your question to make it better and so that people who will donate their time to help you solve your problem don't have to work so hard to do so, you should get up-votes to offset a single down-vote and maybe the person who down-voted will reverse it (wasn't me). Finally, remember that a down-vote is just a meaningless Internet point, it's not cash.
1d
comment Behavior of case sensitivity of RAISERROR when run remotely
Then I would contact Microsoft support. They can help you attach a debugger and figure out what is going wrong. I don't think your peers will be able to help because that isn't normal and we won't be able to reproduce / troubleshoot.
1d
comment Why dropping all foreign keys from a script is not working?
@adamkim Of course, you can store the contents of @create in a table and pull it out later. I demonstrate something quite similar here.
1d
comment Behavior of case sensitivity of RAISERROR when run remotely
Is it possible your network is just flaky and the same thing would happen even if you never issued explicit raiserror calls in upper or lower case?
1d
comment Behavior of case sensitivity of RAISERROR when run remotely
I can't reproduce this problem - keywords in SQL Server are not case sensitive. Can you provide some more details, including @@version for your remote server, whether it's Azure or on Amazon or in your data center, version in Help > About for SSMS, and whether you can reproduce this on any other local machine connecting to the remote server.
1d
comment Does @@FETCH_STATUS have (or need) an equivalent to SCOPE_IDENTITY?
And if you think you need nested cursors, post your query and requirements as a question, plenty of people will be willing to help you change that...
1d
revised Does @@FETCH_STATUS have (or need) an equivalent to SCOPE_IDENTITY?
deleted 1 character in body
1d
comment Timeouts on Full-Text Search when using CONTAINS(*, 'value1 OR value2 OR … valueN')
Can you post the .sqlplan files somewhere?