Viewing 15 posts - 31,021 through 31,035 (of 49,552 total)
To move tables from one database to another you will need to create new tables and copy data over. There's no 'renaming', the tables in different databases will be in...
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
August 26, 2010 at 4:23 pm
Lennie (8/26/2010)
Hi Pussy Cat,I did read your earlier statement and found that there is no proper coding
Um, I don't know what you're reading, but the third and fourth lines...
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
August 26, 2010 at 4:17 pm
Since we seem to be sharing tales of woe, here's some things about the project I'm currently doing.
The deadline has been set for about 3 weeks.
The requirements were finished and...
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
August 26, 2010 at 4:05 pm
Steve Jones - Editor (8/26/2010)
And for those of you looking for a humorous diversion: http://bit.ly/bSaC3q
Sometimes I just wonder.....
Found this on Sean's blog. Fully agree
http://www.midnightdba.com/DBARant/?p=11
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
August 26, 2010 at 3:37 pm
Dunno if you maybe missed my post
GilaMonster (8/26/2010)
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
August 26, 2010 at 3:31 pm
The maximum size that a log file can be in SQL (all current versions) is 2TB. You can look that up in Books online. Hence a log that's got unrestricted...
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
August 26, 2010 at 3:30 pm
CirquedeSQLeil (8/26/2010)
How do you convince somebody that archive data should not be changed?Data integrity didn't work
Point in time visibility did not work
Reporting consistency did not work
Legal implications? It'd be 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
August 26, 2010 at 11:31 am
It won't be 2046 MB, it's 2046GB i.e. 2 TB and that's the maximum allowable size for a log file. Hence it's the same as unrestricted.
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
August 26, 2010 at 11:22 am
Please note: 2 year old thread.
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
August 26, 2010 at 9:03 am
Paul White NZ (8/26/2010)
No wonder the Springboks haven't won a game yet.
Cause our coach needs taking out and shooting?
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
August 26, 2010 at 8:36 am
chugghin (8/26/2010)
but the overall query will run for a week of data (somewhere in the neighborhood of about 60000 rows) in about 25-30 seconds.
That's hellishly slow for that...
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
August 26, 2010 at 8:29 am
snehagupte (8/26/2010)
Can anybody have got clue for the solution, im facing the same problem, however no changes has been done what so ever.
Continues here: http://www.sqlservercentral.com/Forums/Topic975553-146-1.aspx
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
August 26, 2010 at 6:37 am
Abhijit More (8/26/2010)
But what would eb the case where no record is deleted/ updated. In this case also does sql server reads some data?
Yes, it has to read at least...
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
August 26, 2010 at 5:28 am
Why both partition by id and order by id? You're saying that you want the row number to start from 1 for each new ID. Is that really what you...
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
August 26, 2010 at 5:26 am
Bhuvnesh (8/26/2010)
sys.sysindexes doesn't provide its metadata information
No it won't. sysindexes is deprecated and only included for backward compatibility with SQL 2000. Since SQL 2000 did not have include columns,...
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
August 26, 2010 at 4:52 am
Viewing 15 posts - 31,021 through 31,035 (of 49,552 total)