Viewing 15 posts - 5,911 through 5,925 (of 49,552 total)
I second the recommendation of Lightswitch, it's what it's designed for. There's lots of pitfalls in 'simple' PHP pages, not least of which are very common security mistakes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 2:15 pm
tshad (5/16/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 2:13 pm
Start my identifying which of the database files have the heaviest IO load and the highest delays on them. The answer to your question comes from the data. If a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 11:25 am
Jeff Moden (5/8/2015)
I've found that it's usually not the long running queries that are a problem. It's usually the most frequently run queries that are the problem.
This....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 16, 2015 at 10:14 am
afw (5/15/2015)
All restore sequences begin with either a full backup or filegroup backup. When restoring backups, you have the option to terminate the restore process at any point and make...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 3:29 pm
David Webb-CDS (5/15/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 3:24 pm
Offhand, no idea. Is your SQL instance patched? You may also consider contacting Microsoft Customer Support.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 12:55 pm
The database BCCrestore already exists. Use a different name.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 12:53 pm
Ed Wagner (5/15/2015)
SQLRNNR (5/15/2015)
GilaMonster (5/14/2015)
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 11:03 am
No.
You'll need to move the backup file to the server that the SQL instance is running on. Speak to your DBA or sysadmin if you don't have access to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 11:02 am
Sapen (5/15/2015)
Eirikur Eiriksson (5/14/2015)
Sapen (5/14/2015)
I am using sql2012 se and we want to use couchbase to store some data as documents. So the database will be Hybrid(partly SQLServer and Partly...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 7:37 am
It's possible. If you want to research, the term used for this scenario is 'republishing'
However, if you want to migrate, database mirroring or log shipping may be easier to use....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 7:27 am
You can't avoid the optimiser. Even the USE PLAN hint requires that the optimiser runs the optimisation process until it finds the plan specified. Hence it can actually increase the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 6:21 am
Consider seeing if there are any non-profits in your area that might want some DB work done.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 6:16 am
Luis Cazares (5/14/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 15, 2015 at 6:16 am
Viewing 15 posts - 5,911 through 5,925 (of 49,552 total)