Reputation
5,397
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 8 25
Newest
 Enlightened
Impact
~194k people reached

1h
answered Queries without Good Enough Plan Found
1d
answered Using SQLCMD with Variables
1d
awarded  Enlightened
1d
awarded  Nice Answer
2d
answered Are cursors/While loops the only way to make administrative changes to multiple databases?
Apr
30
answered Database stored procedure with a “preview mode”
Apr
29
comment Is the hierarchyid CLR open-source?
I was interested to know what you are modelling. Can you describe?
Apr
27
comment SPID Change for a process?
Does your application have a connection timeout ( eg 30 seconds ) and retry logic? That could account for it.
Apr
25
comment Problem inserting into table from trace file consumes all space in tempdb
Just to see if you get a different result, open the trace with SQL Profiler and use its "Save As > Trace Table ..." option from the file menu. How does that behave?
Apr
24
revised Finding hash match aggregate
contains XQuery function added to extend search for other types of aggregate (eg Partial)
Apr
23
comment How is powershell commonly used in SQL server?
You can use SMO with Powershell to easily script out database objects, databases and data. Here's an example I did a few years ago: social.msdn.microsoft.com/Forums/sqlserver/en-US/…
Apr
20
awarded  Outspoken
Apr
18
comment SQL Merge Statement Spending Large Amount of Time Sorting on Primary Key
Pair up the staging table (as per John's suggestion) with the Oracle Attunity Connectors in SSIS. Superb performance on pull from Oracle in my experience.
Apr
18
revised Msg 39011, SQL Server was unable to communicate with the LaunchPad service
RC2 onwards setup.
Apr
12
comment SQL Server: no search results caused by noise words
LANGUAGE is one of the arguments of the CREATE FULLTEXT INDEX command. I suggest you have a good read over this article.
Apr
12
comment SQL Server: no search results caused by noise words
You might be better off dropping the existing full-text index and rebuilding from scratch in 2014 to see if you get a different behaviour. You should also try running some tests with sys.dm_fts_parser eg something like this: SELECT * FROM sys.dm_fts_parser( '"test a n noise the word"', 1033, 0, 0 )
Apr
6
revised Change the system wide default for maxrecursion
Note about possible bug in self-answer
Apr
6
answered Change the system wide default for maxrecursion
Apr
6
comment SQL not engaging parallelism for extremely large query
The SQL in the execution plan stands a good chance of being truncated as it is ~630 lines so please post the full query. Gist is also a popular place to do that.
Apr
5
awarded  Nice Answer