SQL Database User
Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql login (user1). Can I create the sql login on server3 and copy the [...]

Answer Question   |  September 15, 2009  9:22 PM
SQL, SQL Server, SQL Server 2005, SQL Server backup, SQL Server security

SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes
I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run and it is [...]

Answer Question   |  September 16, 2009  4:15 PM
SQL, SQL performance, SQL Server Reporting Services, SSRS

App-V application license requirements
So if the receiver of the App-V application which has an embedded SQL Server in it already has a liscense to access an SQL Server then ther are no new liscenses required. If that is not the case then the receiver of the App-V application will need to purcahse what? This question is from the [...]

Answer Question   |  September 14, 2009  1:47 PM
App-V, Application virtualization, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, SQL Server licensing

Applying snapshot on Subscriber – SQL SERVER 2005
hi, i’ve read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and the Distribution Agent begins processing it, stop the Distribution Agent. Once the SQL Server Agent job has stopped, [...]

Answer Question   |  September 14, 2009  6:21 PM
Snapshot, SQL Server 2005, SQL Server snapshot backup

What are the licensing requirements associated with App-V?
What are the licensing requirements associated with App-V? That is if the application being virtualized uses SQL Server and it is part of the virtual application does the user of the App-V package require a full SQL Server license? This question is from the Microsoft Virtualization Chat held on August 27th.

Answer Question   |  September 14, 2009  5:25 PM
App-V, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server

Controlling tempdb Growth
I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of [...]

Answer Question   |  September 11, 2009  2:22 PM
SQL Server, SQL Server 2005, TempDB

can one use App-V to install SQL Server as part of a virtualized application?
can one use App-V to install SQL Server as part of a virtualized application? This question is from the Microsoft Virtualization Chat held on August 27th.

Answer Question   |  September 11, 2009  1:55 PM
App-V, Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL Server, Virtualized Applications

How can one ‘v-app’ an application that uses a db like SQL 2008 express?
How can one ‘v-app’ an application that uses a db like SQL 2008 express? This question is from the Microsoft Virtualization Chat held on August 27th.

Answer Question   |  September 10, 2009  9:23 PM
Microsoft virtualization, Microsoft Virtualization Chat 8/27, SQL 2008, SQL Express, SQL Express 2008, V-App, Virtual Apps

Data model for Custom fields and Custom forms.
Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta data details of [...]

Answer Question   |  September 10, 2009  8:11 PM
data model, Dynamic Forms and fields, performance, SQL Server database

Community Update: The IT Blog Top 10 for Sept. 10, 2009
As part of a new feature on the Community Blog, each week we’ll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an [...]

Answer Question   |  September 10, 2009  3:28 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Error copying indexes in DTS package
I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a [...]

Answer Question   |  September 10, 2009  2:18 PM
DTS, Indexes

Why should I use SSAS for Predictive Analytics?
We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us?

Answer Question   |  September 8, 2009  2:30 PM
Microsoft SQL Server, SQL Server 2008, SSAS 2008

SQL server 2000 increase database auto-grow
Does it matter to increase database auto-grow from 10MB to 250MB? We expereience some bottleneck at database size of 36 GB for a reporting database. But the physical disk has 100 GB free disk space, CPU usage is not high. Occasionally has some COM error Not sure what the problem it is

Answer Question   |  September 9, 2009  1:32 PM
Auto Grow, Database Sizing, SQL Server 2000

SQL convert numeric to date format
How can I convert an 8 digit numeric (format ccyymmdd) into a real datefield to be used in date arithmetics? I need to calculate the number of months between the month (current date) and a date represented in my DB as an 8 digit numeric with format “ccyymmdd”. Therefor (I assume) I need to convert my [...]

Answer Question   |  April 19, 2013  2:13 PM
SQL, SQL Date Calculation, SQL datetime

How to load an Image from an SQL Server 2005 database using VB.NET 2005 coding?
            After a lot of trying and hard work I finally manged to store an image into an SQL Server database using a byte array. But now I’m stuck at how to retrieve it back into my application’s picture box control.              This is what I need [...]

Answer Question   |  March 21, 2011  2:18 AM
SQL Server 2005, VB.NET, VB.NET 2005, VB.NET 2005 programming

SQL 2008 mirroring – are jobs active on mirror on just on failover?
When mirroring SQL 2008 Databases when the principal is active do the jobs run on the mirror or just on failover?

Answer Question   |  September 4, 2009  9:03 PM
SQL 2008 Mirroring

SQL dynamic date calc.
How shall the WHERE clause look for this challenge: Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months. As you can see this may be expressed as [em]rolling 36 full months plus current month[/em]. Any help will be apreciated. Dan

Answer Question   |  September 7, 2009  4:45 PM
IBM 9407 M15, SQL, SQL Calculations, SQL Dynamic Date Calculation

On Error Resume Next SQL Server 2005
Is there to achieve On Error Resume Next? insert into table1 select top 1000 columnname from table2 It should continue inserting the next record even if there is an error. It should not stop the execution. It should simply skip the errors. thanks in advance.      

Answer Question   |  September 5, 2009  10:28 AM
SQL Server 2005, SQL Server error messages, SQL Server errors

SQL select loop list?
Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through [...]

Answer Question   |  September 9, 2009  3:25 AM
SELECT, SQL 2008, SQL Select, T-SQL, T-SQL 2008

Aren’t correlation IDs ok in MSSQL for an UPDATE statement?
I’m getting the following error with the attached SQL statment on MSSQL: UPDATE IMMUNE I

Answer Question   |  September 2, 2009  4:35 PM
SQL error messages, SQL tables