Viewing 10 posts - 1 through 10 (of 10 total)
Over the years have seen many solutions that use SQL Express on the back end. We started using this
The best part about DB Health assist is that it...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
May 12, 2017 at 7:06 am
Very Nice! Sorry I tried to give an excellent rating, but my mouse malfunctioned.
I'll try the size history method that you mentioned, looks like a clever approach.
We use a...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
June 9, 2016 at 6:04 am
I agree - I prefer to not use temp tables if I can.
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
January 22, 2016 at 1:10 pm
yes you are correct
I actually devised a script to change the collation of every object, but then realized that the other constraints were blocking me.
It would have been...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
January 14, 2016 at 8:02 am
Sorry - it actually means "code page 1"
SQL_Latin1_General_CP1_CI_AS:- Latin1-General, case-insensitive,
accent-sensitive, kanatype-insensitive, width-insensitive for Unicode
Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data
I never dreamed it could...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
January 14, 2016 at 7:42 am
I didn't supply an explicit collation string, the string"COLLATE DATABASE_DEFAULT", tells the temp table to use the default collation of the database that was restored no matter what the collation...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
January 14, 2016 at 7:35 am
shouldn't it read: While the Server and ConnectionData fields may seem redundant, the ConnectionData field may contain an (not and) IPV4 or IPV6 address?
BTW: I like your article and I...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
December 18, 2014 at 10:16 am
me too.
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
December 18, 2014 at 8:05 am
In multi-tier applications where you don’t necessarily know how the client will connect, ie browser from a computer, wi-fi, cellular, iPhone app,… and the application may be hosted or in...
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
December 18, 2014 at 8:03 am
Apologies, for the miscommunication. NOT lazy DBA’s, lazy developers. Not all developers are lazy, just many that I’ve met. It is not personal.
Tom Romeo
Practical Compliance Solutions Corp.
One Orient Way - Suite F156.
Rutherford, NJ 07070-2524
--------------------------------
www.complianceabc.com
email: tromeo@complianceabc.com
Phone: 201-728-8809
December 18, 2014 at 7:46 am
Viewing 10 posts - 1 through 10 (of 10 total)