Viewing 15 posts - 20,236 through 20,250 (of 49,552 total)
You can't load balance two or more SQL Servers without huge amounts of work to keep the two databases in sync eg though (peer-to-peer replication). A HTTP load balancer requires...
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
February 18, 2012 at 12:25 pm
Rowles (2/18/2012)
Is the semi-colon ";" optional when creating a CTE?For example, a CTE could start with ";WITH" or "WITH" right?
A CTE starts with WITH. A CTE requires that the previous...
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
February 18, 2012 at 12:22 pm
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
February 18, 2012 at 10:40 am
I'm going to assume that there are management tools installed on the server. From the object explorer in Management Studio, right click the database and chose backup. Once complete copy...
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
February 18, 2012 at 7:35 am
Take a backup of the hosted database (backup database ....), copy the backup file locally. Restore the backup
Do note that going the other way is not possible, because the local...
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
February 18, 2012 at 5:10 am
GilaMonster (2/16/2012)
Please post new questions in a new thread, that has nothing to do with backup files
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
February 18, 2012 at 5:07 am
The log is not intended to be human readable (and the article only covers reading the currently active log, not a log backup). Log reader tools are around $1000 per...
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
February 18, 2012 at 2:38 am
I can't tell whether it's correct without knowing what it's supposed to do. Does it run? Does it return the results you want? If yes to both, it's probably correct.
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
February 18, 2012 at 2:36 am
The entire log is not included in a backup, the only portion of the log that is is (more or less, roughly) the portion written over the period of 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
February 18, 2012 at 2:34 am
EdwinGene (2/17/2012)
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
February 17, 2012 at 3:28 pm
stephenhai (2/17/2012)
but it is a working table...do you care to use truncate or drop??
Depends what you're trying to achieve.
Truncate removes all the data from the table, but leaves the empty...
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
February 17, 2012 at 1:00 pm
http://sqlinthewild.co.za/index.php/2011/05/03/indexing-for-ors/
Though in that example, it's unlikely that any index would be used except for a scan. That will most likely scan both tables (because there's no predicate that reduces 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
February 17, 2012 at 11:18 am
The other disadvantage (for nonclustered indexes) is that the index can't be used while the rebuild is in progress. Normally rebuilding a nonclustered index makes the table read-only, but 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
February 17, 2012 at 10:51 am
Eugene Elutin (2/17/2012)
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
February 17, 2012 at 9:36 am
Eugene Elutin (2/17/2012)
GilaMonster (2/17/2012)
Eugene Elutin (2/17/2012)
GilaMonster (2/17/2012)
An nvarchar(40) holds 40 characters.and its length is 80 bytes, to accomodate unicode...
Its length is anything from 2 bytes to 82 bytes depending on...
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
February 17, 2012 at 9:13 am
Viewing 15 posts - 20,236 through 20,250 (of 49,552 total)