Help navigating SQL Server 2008 database?
Fascinating problem… This can be solved by applying some simple rules and a recursive stored procedure. First, I would decide to apply a rule that says we will apply the payments to the oldest invoices first. That means that to solve this, I would retrieve the account records for all open invoices into an internal [...]

View Answer   |  August 25, 2010  9:28 PM
SQL Server 2008, SQL Server 2008 administration, SQL Server database, SQL Server tables, VB.NET

How does exchange 2010 email archiving work?
<a href=”https://www.microsoft.com/exchange/2010/en/us/archiving-and-retention.aspx”>Here is a helpful site that answers your questions</a>. I found it to be very informative as I had the same questions and more.

View Answer   |  August 25, 2010  4:12 PM
Exchange 2010, Exchange 2010 Administration, Exchange 2010 Archiving, Exchange Back-End Servers, SQL Database

SQL problem: Adapting code fragment
Not sure why you want to try to use that fragment as a starting point. Assuming that “ancnumber” is “ancestry number” and 720 is the code for filipino, the following will give the answer: select count(*) as TotalPopulation, tmp.Filipinos, cast ((100.0 * tmp.Filipinos / count(*)) as decimal(5.2)) as PercentFilipinos from popdata, ( select count(*) as [...]

View Answer   |  August 23, 2010  6:58 PM
Access 2007, SQL, SQL commands, SQL Server

Using mdf file in website
You’ll need to have the hosting company attach the database to the SQL Server instance then have them give you the connection string with the server name, username, password and database name.

View Answer   |  August 22, 2010  12:17 AM
.MDF files, ASP.NET, SQL Server, SQL Server 2005, Visual Studio

Database Security: SQL Server 2005 security login
By using the CREATE LOGIN statement. <pre>CREATE LOGIN [YourDomainWindowsLogin] FROM WINDOWS GO CREATE LOGIN SQLLogin WITH PASSWORD=’YourPassword’ GO</pre> You can also create logins within the SQL Server management studio. Connect to the database in the Object Explorer. Open the server > Security > Logins and create logins as needed.

View Answer   |  August 22, 2010  12:14 AM
Database security, SQL Server 2005, SQL Server 2005 security, SQL Server security, SQL Server Security Login, Windows XP

Updating SQL express to SQL 2008 R2 on server 2008 with sharepoint 2007
Look at the WorkGroup edition of SQL Server. Its a little bit cheaper and it doesn’t have the database size limit. You can upgrade from SQL 2005 Express to SQL 2008 Workgroup (or higher) directly. You don’t need to upgrade from SQL 2005 Express to SQL 2005 standard first. If you want you can upgrade [...]

View Answer   |  August 20, 2010  9:19 PM
SharePoint 2007, SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server 2008 Adoption, SQL Server Upgrade, Windows Server 2008

Microsoft Retail Management System and SQL Server “Write” error
Those error’s aren’t SQL Server error messages. You might want to give Microsoft Support a call and have them help figure out what’s going on with the system. Something may not be configured correctly.

View Answer   |  August 18, 2010  6:56 PM
Microsoft Retail Management, RMS, SQL Express, SQL Server 2005, SQL Server 2005 error messages, SQL Server error messages, Windows XP

Importing large sets of Excel 2000 data to SQL database
When you open the SQL Server Management Studio (SQL Server 2005+) or Enterprise Manager (SQL 2000 and older) you can use the import/export wizard to import data. Right click on the database you want to import the data into and select all tasks, then select the import data option. The wizard will allow you to [...]

View Answer   |  August 18, 2010  6:51 PM
Data migration, Excel 2000, Excel Database, Excel worksheets, SQL Database, SQL migration

Incremental backup in SQL server 2005 and SQL Server 2005 express
SQL Server doesn’t have incremental backups. We have Differential backups instead. A differential backup is all the changes since the last full backup. Use the BACKUP DATABASE command just like you would to do a full backup but add in the DIFFERENTIAL flag. <pre>BACKUP DATABASE YourDatabase TO DISK=’D:PathToYourFile.bak’ WITH DIFFERENTIAL</pre> This can be done with [...]

View Answer   |  August 18, 2010  6:47 PM
Backup, Incremental backup, SQL Server 2005, SQL Server 2005 backup, SQL Server 2005 Express, SQL Server backup

High Disk usage on SQL Server 2005
This all depends on what was done within the change script. It a lot of data was backed up that could explain it. Does your QA database have the same amount of data as your production database? You should really contact your software vendor and ask them. Anyone here will just be guessing where they [...]

View Answer   |  August 18, 2010  6:43 PM
Disk usage, SQL Server 2005, SQL Server 2005 (32-bit), SQL Server 2005 Database, SQL Server 3.5 Compact Edition

SQL Server 2005 & 2008 on a Cluster in Production
There are no problems running one SQL 2005 instance and one SQL 2008 instance. They will be separate instances with one as he default instance and one as a named instance.

View Answer   |  August 18, 2010  6:33 PM
Cluster management, Clustered servers, SQL Server (64-bit), SQL Server 2005, SQL Server 2008, SQL Server 2008 64-bit, SQL Server administration, SQL Server clustering

ASP Web page database?
Microsoft SQL Server is a multi-user database which is designed to be a robust scalable database platform. You can start with the Express Edition which has a 4 Gig limit on the amount of data it will hold. Once you grow beyond that you can quickly and easily upgrade to a larger version which doesn’t [...]

View Answer   |  August 18, 2010  6:31 PM
ASP.NET, ASP.NET Web applications, SQL Access, SQL Database, SQL Developer

Recovering data from crashed database
Restore the full backup, then restore the most recent differential backup. Then restore the logs taken from after the differential backup until current. So basically sunday’s full, then Yesterday’s differential, then the log backups taken aften 1pm yesterday.

View Answer   |  August 18, 2010  6:27 PM
Backup, Backup & recovery, Database Recovery, DBA, SQL Server, SQL Server backup

Writing procedures for two databases I designed. How do I print the screens to attach to the procedure?
Other than the standard ALT-PRNTSCRN or CTRL-PRNTSCRN to capture windows, I like to use the free <a href=”http://www.gadwin.com/printscreen/”>Gadwin Printscreen utility</a>. Been very useful for several years for me now – even works on Win7.

View Answer   |  August 16, 2010  6:13 PM
Database design, Print screen, Stored Procedures

SQL Server 2008 SSIS Update Command Performance Issue
Are you doing row by row updates? What does the execution plan for the update statement look like? SQL Server is more efficient when doing larger bulk operations. Instead try dumping the data into a staging table, then updating all the rows (or larger batches of rows say 1000 or 5000 at a time) from [...]

View Answer   |  August 13, 2010  2:32 PM
SQL Query Analyzer, SQL Server, SQL Server 2008, SQL Server 2008 R2, SSIS

Joining 3 tables in SQL Server 2005
As you didn’t include the tables, I’ll just give you a basic syntax. <pre>SELECT t1.*, t3.*, t2.col1 FROM t1 JOIN t2 ON t1.col1 = t2.col4 JOIN t3 ON t2.col2 = t3.col1 WHERE t1.Col5 = ‘test’</pre>

View Answer   |  August 12, 2010  11:17 PM
SQL Query, SQL query optimization, SQL Server, SQL Server 2005, SQL Server Query, SQL tables

Crystal Reports – Rounding Nearest 1/8 Mile
You could create a formula a bit like this… ‘Find the position of the decimal in your mileage field Local NumberVar DecimalPlace := InStr(Mileage,”.”); ‘Get the decimal remeinder of mileage local NumberVar DecimalValue := Left(DISTANCEFIELD,DecimalPlace); ‘Work out if in the 1st, 2nd 3rd etc. 8th of a mile, using 0.125 as 1/8th if DecimalValue = [...]

View Answer   |  August 12, 2010  1:53 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports formulas, SQL Server, SQL Server 2005

Automatic backups for production databases without taking SQL server offline
You can set up nightly backups using the SQL Maintenance plan, then backup that flat file with whatever backup software you use for your other servers. There is backup software available that will back up live databases as well, but that would take research and planning to find the one you would like to use [...]

View Answer   |  August 10, 2010  8:08 PM
Backup, SQL Server, SQL Server 2008, Sql Server 2008 Backup

How to roll back service pack in SQL server 2005
There is no rollback for a SQL Service pack. You’ll need to uninstall the SQL Server engine, then reinstall and patch up to the level you wish to be patched to.

View Answer   |  August 10, 2010  8:03 PM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server Service Packs

SQL Server 2005 Performance
SQL Server doesn’t track the number of changes to the database is a counter you can grab. The best way to figure this out is to work with the application developer and see how many database calls there are, and how many of those are read and how many of those are writes. Then work [...]

View Answer   |  August 10, 2010  7:22 PM
SQL 2005 Database, SQL Server, SQL Server 2005, SQL Server 2005 performance, SQL Server performance