Reputation
3,823
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
1 5 18
Newest
 Yearling
Impact
~155k people reached

Jan
14
answered Create a plan guide to cache (lazy spool) CTE result
Jan
6
answered SQL Server “fix” query for Hash Match instead of Nested Loops
Jan
3
comment Finding the names and the year of the movies that have at least 5 actors
"At least 5" would translate to me as "> 4" or ">= 5" I think.
Jan
1
answered SQLCMD :connect dynamic parameter
Dec
16
answered PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on
Nov
24
comment Parsing Typed XML with a default namespace and inconsistent root node
No problem. Don't be afraid to ask questions as there are some very knowledgeable guys here on that topic eg @MikaelEriksson. When I was learning about SQL Server XML and XQuery this article really helped me: msdn.microsoft.com/en-us/library/ms345122(SQL.90).aspx
Nov
23
answered Parsing Typed XML with a default namespace and inconsistent root node
Nov
11
answered Using Percentile_Disc to compute Median/Interquartiles
Nov
4
revised Modify XML: attributes into elements
Update table method added.
Nov
4
answered Modify XML: attributes into elements
Oct
14
answered Convert string numeric values with comma as decimal separator to NUMERIC(10, 2)
Oct
12
answered SQL Server sqlcmd setvar depending of selected database
Sep
11
awarded  Yearling
Sep
3
comment Why would SQL Server remain unresponsive after a slow query completes?
Assuming the server is 64-bit and a dedicated SQL Server machine, I would probably cap that at 12GB eg EXEC sp_configure 'max server memory (MB)', 12288 -- 12GB RECONFIGURE
Sep
3
comment Why would SQL Server remain unresponsive after a slow query completes?
How much memory has the server got? What is SQL Server capped at?
Sep
3
answered FullTextSearch indexing/searching words with special characters
Jul
30
answered Is an SQL Server trace 'considered harmful' in production?
Jul
30
comment Is an SQL Server trace 'considered harmful' in production?
We know why, the default RML template contains the SQL statement level tracing events which could easily bring a server to its knees under the wrong conditions, for example a scalar function in a SELECT statement running across a big table.
Jul
30
answered Introduce or not introduce SSIS to an ETL project
Jul
29
answered SSIS - Best way to insert large number of rows