Reputation
4,812
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 18 43
Impact
~476k people reached

Aug
11
comment UDF in check constraint — downside?
I would prefer this type of data integrity handling to be performed in the application before making it to the databae. Letting the update take place, then checking the data to see if it breaks the rules, rolling back if it does committing if it does not...while it is a valid way of doing it you are opening the data up to the ever popular turbo button "with no lock", allowing dirty reads of the data.
Aug
7
comment Composing the “ultimate database maintenance script”
Shrinking your database will cause internal fragmentation and as a result a reduction in performance of your queries. If you are going to shrink a database, you need to rebuild your indexes. You should also take a full backup afterwards to re-establish the log chain.
Jul
24
comment Efficient way of changing VARCHAR to NVARCHAR fields in a large table in SQL Server 2008?
Bonus points for using batches. Too many people have forgotten about this ancient and effective technique.
Jul
23
revised Import data problem in SQL Server 2008
Fixed some typos; added 1 characters in body
Jul
20
comment Why do wildcards in GROUP BY statements not work?
@Aaron, neat trick with dragging the columns from object explorer. Any idea why it also works for Keys, Constraints and Statistics but not for Indexes?
Jul
17
awarded  Revival
Jul
11
awarded  sql-server
Jul
10
answered can access to a view be controlled by access to a referenced table?
Jun
29
answered What are the edges of typical (or specific) paid databases like oracle of mysql compared to the free oness?
Jun
27
answered DBA to work from home
Jun
21
answered How can I query to do this?
Jun
19
comment Where is this mystery trace going (SQL Server 2000)?
If you had sudden disk growth, and the trace was the cause, you should be able to find the file. Do a search on the drive for all *.trc files. I suspect the two are un-related, however. You still need to know why the trace is there and who started it.
Jun
15
revised Can You Replicate Sequences
Added clarification.
Jun
11
awarded  Peer Pressure
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
4
answered Tutorial in datamining
Jun
3
answered Electricity off while shrinking database, how can I recover my database?
Jun
1
accepted Is there a way to display current noise words in SQL 2000 Full Text Indexing?
Jun
1
comment Is there a way to display current noise words in SQL 2000 Full Text Indexing?
That is what I was afraid of.