Viewing 15 posts - 38,056 through 38,070 (of 49,552 total)
Write an SSIS package, maybe using the transfer database task, or maybe broken down with transfer objects and data flows, then schedule that package daily (using SQL agent)
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
June 29, 2009 at 2:18 pm
Besides, sys.sql_logins, sys.server_principals and syslogins aren't tables. They're views. The underlying tables are hidden and aren't even queryable.
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
June 29, 2009 at 1:55 pm
Peso (6/29/2009)
So there's nothing...
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
June 29, 2009 at 1:47 pm
Absolutely it's necessary. In full recovery the transaction log does not get truncated except by a log backup. No log backups, no reuse of the log file, the log file...
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
June 29, 2009 at 10:27 am
Lynn Pettis (6/29/2009)
If I remember the Modeling class at the TDWI conference a couple of years ago, 6NF is used to eliminate nulls being stored in a database.
There's actually...
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
June 29, 2009 at 10:23 am
websites2 (6/29/2009)
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
June 29, 2009 at 10:18 am
On 64-bit you need to set max memory. Otherwise SQL will allocate until the OS is memory starged, and then it will get paged out (if the SQL service account...
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
June 29, 2009 at 10:04 am
GSquared (6/29/2009)
GilaMonster (6/29/2009)
Isn't that pretty much 6th normal form? Not one I'd use in anything other than the most extreme cases.
6NF is either Domain/Key NF or Temporal NF, per what...
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
June 29, 2009 at 9:51 am
Paul White (6/29/2009)
😀 Don't tell me about it - I didn't post the daftness!
I didn't say it was daft, I just said I don't know why anyone would do it....
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
June 29, 2009 at 9:26 am
Gaby Abed (6/29/2009)
Regarding the Nth Normal Form, and I guess on a more philosophical level, is it true that the more normalized a database is, the less fragmentation occurs
I'd say...
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
June 29, 2009 at 9:13 am
Please read through this - Managing Transaction Logs[/url]
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
June 29, 2009 at 8:49 am
That reminds me, I have photos of my old office
http://picasaweb.google.com/GilaMonster.za/Misc#
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
June 29, 2009 at 8:28 am
SQL Noob (6/29/2009)
It happens because SQL will backup an entire page if there is a change on it, not just the change.
Actually SQL will backup an extent (8 pages) if...
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
June 29, 2009 at 8:22 am
jaclynmcatanzaro (6/26/2009)
Good SQL Server article
You mean 'good collection of stolen content' seeing as most of that was copyrighted material reposted without permission and frequently without attribution or links
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
June 29, 2009 at 8:11 am
GSquared (6/29/2009)
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
June 29, 2009 at 8:09 am
Viewing 15 posts - 38,056 through 38,070 (of 49,552 total)