Viewing 15 posts - 24,346 through 24,360 (of 26,486 total)
Out of curiosity, what are the values for the first_lsn, last_lsn, checkpoint_lsn, database_backup_lsn, and last_recovery_fork_guid for these three backups from msdb.dbo.backupset?
😎
August 22, 2008 at 2:02 pm
I agree with Matt Miller. This is a good candidate for using a tally table.
😎
August 22, 2008 at 1:28 pm
From BOL:
A differential file backup requires a full file backup as a base. For more information about full file backups, see Full File Backups.
Yes, the file group backup may...
August 22, 2008 at 1:21 pm
Pam Brisjar (8/22/2008)
Attempt to restore differential backup and get "backup cannot be restored because the database has not been restored to the correct earlier...
August 22, 2008 at 1:03 pm
I'm a visually oriented type, based on the sample data provided what would the output look like?
😎
August 22, 2008 at 12:49 pm
I don't think this is an IT only phenomenon. I am sure that this occurs in many occupations. The use of automated processes to prescan applicants is used...
August 22, 2008 at 12:38 pm
Guessing here, but is this what you are trying to accomplish?
Current:
LastName FirstName SSN
Duck ...
August 22, 2008 at 10:32 am
SQL Noob (8/22/2008)
Thayal Muhunthan (8/22/2008)
If we have 3 users accessing the SQL server using an third party application, do we calculate 3 or 1 CAL...
August 22, 2008 at 10:15 am
usman.tanveer (8/22/2008)
August 22, 2008 at 8:53 am
By the number of users. Even if you use an application server with only 20 connections from the app server to the database server, you have to count the...
August 22, 2008 at 8:38 am
Just be sure that while using the developer edition that you don't use features that are not available in the standard edition if that is your target production environment.
😎
August 22, 2008 at 8:35 am
It is a mind set, but not necessarily a mind set of a procedural mind. I use the begin end around my procedures. When I write them I...
August 21, 2008 at 12:00 pm
Thayal Muhunthan (8/21/2008)
We have 20 SQL 2000 and 5 SQL 2005 licences...
August 21, 2008 at 10:49 am
Thayal Muhunthan (8/21/2008)
We have 20 SQL 2000 and 5 SQL 2005 licences...
August 21, 2008 at 10:42 am
SQL Noob (8/21/2008)
you can do CPU licensing but that's only if you have tens of thousands of internet users hitting your db, otherwise it doesn't make sense.
Not true. ...
August 21, 2008 at 10:28 am
Viewing 15 posts - 24,346 through 24,360 (of 26,486 total)