Viewing 15 posts - 2,266 through 2,280 (of 2,494 total)
Each transaction log backup contains only the log information that was created following the previous transaction log backup. Transaction log backups are only valid when the database is in Full...
February 23, 2006 at 7:18 am
1) Cross-check field sizes. In particular Integer can mean 2-byte or 4-byte in different systems. Most Cobol and DB2 data types map well to SQL data types apart from date...
February 23, 2006 at 4:26 am
If you are using EM, the default path for saving script files is the 'My Documents' path. You can change this to some other value by right-clicking the My Documents icon...
February 22, 2006 at 2:53 am
Don't forget to think outside the (SQL) box.
Many sites use a disk replication product such as Double-Take or SAN replication to copy their SQL data to another site. In this scenario...
February 22, 2006 at 2:48 am
You can use Cast or Convert to specify a given date format. If you want to do anything more then Convert gives you, then do it in .Net code. It...
February 20, 2006 at 4:32 am
Beware of allocating multiple files to the same filegroup if they will be on the same disks, especially if you are already having I-O problems. Wintel servers often have limited...
February 20, 2006 at 4:28 am
This needs to be driven by the business. If there are no formal SLAs agreed, then this must be the first step. When you have a written and signed-off document...
February 13, 2006 at 3:05 am
Big is as big does. Back in 2000 I was involved in some work for the UK Land Registry. Back then their main system was growing at about 10 GB...
February 13, 2006 at 2:49 am
I have no issues with the concept of consolidating multiple production instances on to fewer servers. Likewise multiple test instances could be consolidated to few (non-production!) servers. If you look...
February 10, 2006 at 3:37 am
The best advice is: stop shrinking tempdb!!
You should plan to have a Tempdb that is large enough for your workload. If it needs 20GB then plan for 20GB. On our...
February 9, 2006 at 3:25 am
Talk to your System Admin people. It is likely they will have a preferred method of deployment so they can support the boxes. If you add software outside of the...
February 8, 2006 at 2:55 am
I know that with some operating systems, if you store data using a different collation from wher it is processed or displayed, this forces a collation conversion process. Even where source...
February 3, 2006 at 3:09 am
"Freedom of speech is important because it allows you to easily see who are your enemies. If a state prevents freedom of speech it cannot see who are its enemies,...
February 1, 2006 at 3:15 am
You can do this easily in Enterprise Manager. Open the dialogue to cerate a new login, and type BUILTIN\ADMINISTRATOR for the user name.
February 1, 2006 at 3:03 am
If you are using SQL 2005 you can use recursive SQL to generate your data.
The 'DB2 SQL Cookbook' has some interesting examples of this that would work OK in SQL...
January 11, 2006 at 6:23 am
Viewing 15 posts - 2,266 through 2,280 (of 2,494 total)