Sometimes you can not avoid expanding the transaction log. Suppose during a short maintenance window, you purge years of old data. You will expand the transaction log, even...

The other 90% of the world already benefit from the software.

How so?  Ever hear of exports?  Consider any product manufactured, distributed, managed with software.  Pharmaceuticals are exported.  The software wasn't exported,...

For this query, you are likely to get better performance by indexing LC.lkup_postcode, and creating an index on CL.B_POSTCODE and an index on CL.PRV_PCODE.  Adding lkup_area and possibly prv_nuts4 to one or...

Don't change them.  Change the server's name.  Sort-of.

Migrate the packages to the new server.  Using the client config tool on the new server, define an alias that uses the name of...

If you design the table and alter it through SQL Enterprise mangler, it will recreate the table.  Does the table alteration requires data to change?   Or is it a metadata-only change?...

Try concatenating path and name and storing it in variable.  print the file name with msgbox.  Make sure its what you expect.

Try using .ToString and .Value and combining them.  The...

Starting and stopping from the command line

net start

net stop

Pause from the command line

net pause MSSQL$instancename

52.7 to 47.3, even split, lots of guessing?

Redo first because subsequent transactions affecting the same data may have to be undone.

Articles do this too.  Hate it.  Best work around for articles is to view printer format.  But all the the page formats should not be wide.

You can run that script under WSH without a development environment.  You dim the variables, but without the type (You have to do createobject), and comment out with a single quote the...

An index on datetime which only has a calendar date might be more useful than you think.  1 day out of 365 is 0.27%.  0.27% is selective.  I expect the...

You can use indexes on columns like OrderStatus that have a small number of values.  Hopefully 99% of your orders are completed, but if you need to check the sub-1%...

Say you have a database with 100 tables, with 4 procs each, 400 stored procs beginning with usp_.  Your eyes quickly start to filter out the usp_.   That prefix is...

I had a stored proc that used small tables temporarilly.  I replaced the #temp tables with @table variables and got a performance improvement.  If there is no difference, why was there...