808 reputation
310
bio website drewstechnotes.blogspot.com
location Canada
age 36
visits member for 3 years, 11 months
seen May 14 at 19:05

Big SQL fish in a small SQL pond.


Nov
13
awarded  Nice Answer
Jul
15
awarded  Nice Answer
Jan
18
awarded  Yearling
Jan
18
awarded  Yearling
Jan
18
awarded  Yearling
Jun
29
comment CONTAINS function in MS SQL 2008 R2
The only point I'll add is to be aware of the performance implications of both approaches. For the LIKE approach, SQL Server will have to scan every row when you use LIKE '%name%', but you may get away with range scans when you use LIKE 'Na%' assuming you have an index on the column. There is other overhead associated with the Full text indexing which I won't get into here, I just recommend you read up on both and test them to see what does (and will as data volumes grow) perform best :)
Mar
6
comment Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
Short, simple, to the point so this gets my +1. Do be sure to check out the link to SQLSkills as there is a wealth of good info there.
Feb
23
answered How do I query this 20 million record view faster?
Feb
23
comment How do I query this 20 million record view faster?
The question is tagged for MS SQL Server so rather than "materialized views" we should be talking about "indexed views" ;)
Feb
23
comment Is there a non-DDL way to preserve back-references when staging data into production?
Can you explain what you're doing to create #StagingOrders and what you do to put non-NULL values into OrderID on the Activity table?
Feb
15
answered How do I rename my local SQL development server?
Feb
15
answered Is it possible to install Developer Edition of SQL Server as the primary development server?
Jan
24
comment Using SQL Profiler on a database that's in production
To minimize impact filter as best you can and trace to a file via sp_trace commands. The GUI running remotely will cause the most impact but you can use it to easily generate a script with all your filters that you can quickly modify to dump to files instead. Set the # of files and file size appropriately.
Jan
21
awarded  Quorum
Jan
21
comment Is there any benefit of a primary key that comprises all columns of the table?
I usually tell people they should use a surrogate key unless they want to guarantee fragmented indexes and poor performance. There are always exceptions but very, very few in this case.
Jan
21
answered SQL Server renaming table from another database
Jan
21
awarded  Commentator
Jan
21
comment Possible to run two DBCC INDEXDEFRAG commands simultaneously, each on a different table?
You can't get a more accurate answer than one from the person who wrote it! Don't forget about the IO load associated with doing multiple rebuilds or reorgs at the same time, and be sure to use ALTER INDEX rather than the DBCC command going forward.
Jan
21
comment Is it better to store images in a BLOB or just the URL?
+1 as I'm also in the "don't put file blobs in the database" camp. It's messy, quickly unmanagable, and won't scale well without throwing money at the problem.
Jan
21
comment Is it better to store images in a BLOB or just the URL?
+1 for pointing out the issues with FILESTREAM as it is today. I'm interested in playing with what they're doing in Denali but honestly - the idea still gives me chills! ;)