|
Why don't we have a session called "Experiences in the Field"
18/07/2005 4:14:29 PM
(Total replies: 1)
|
| Was speaking with a doctor and asked him how he kept up to date with everything.
He said they get together every month and present to each other, cases they have worked on. This principle seems quite applicable for the Microsoft User groups.
Have recently passed my SQL Server 2000 Admin and design exams.
Then had an interesting install where this situation wasn't in the "Book".
The situation was were we had to install sql sever on a new box and transfer all objects and databases, but ... |
|
|
|
What is the best way to restore on a new server all the databases etc
15/07/2005 9:47:26 AM
(Total replies: 1)
|
| We are going to fix a database server where everything went haywire when they tried running SQL Server 2000 on a 64 bit box.
We are putting all the databases etc on a new box with Windows 2003 etc.
As far as the books go the best way seems to be:
1: Run checkdb to make sure the databases aren't corrupt
2: Detach all non-system databases and copy to new server
3: Restore the Master and MSDB databases and maybe the Distribution database if replication is used
4: Attach all databases ... |
|
|
|
pivoting a table with hundreds of columns into two
2/05/2005 4:58:16 PM
(Total replies: 1)
|
| Here's one for thought.
Have a table with 300 columns, filtered by memberno to give one recordset.
Want to turn this into two columns with 300 rows.
Column 1 to be the field name
Column 2 to be the value
|
|
|
|
Re: pivoting a table with hundreds of columns into two
16/05/2005 4:29:19 PM
(Total replies: 0)
|
| Thanks,
Will have a go.
The funny thing is the reason for this requirement is SQL Server 2000 Reporting Services and that you can have only one dataset per table/matrix to be able to compare and use the shorter expressions.
So one needs to pivot a dataset to be pivoted again in the matrix object.
So for this product which will be use for about a year, before the new version comes out, stored procedure programming techniques like this are very useful. |
|