SQL Server

The IT Blog Top 10: Oct. 29, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

SQL 2005 will not recognize other local disks

SQL Server Management Studio only recognizes one drive on the server, how do I get it to recognize the other Local disks?  The one disk it does see is also on the AX-100, but it will not list any of the others, even the interanl disk, as options for devices to create databases on or for backup...

How to export excel data to Sql server 2005

How to export excel data to Sql server 2005 Software/Hardware used: Sql server2005 and Ms excel 2007

About Time

Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet   Software/Hardware used: OC

Reducing SQL Server backup and restore time

Our database is big (about 320 GB) and it takes some time to backup and restore. The client wants us to suggest techniques that would reduce the time. I have tried "piecemeal" restoring, which allows you to backup and restore individual filegroups in the database. It works fine with all the...

What is the difference between RAM and Cache Memory in SQL Server 2005?

What is the difference between RAM and Cache Memory? Software/Hardware used: sql server 2005

Techniques for storing SQL Server data online and for backing up the server

For a banking application, I would like to keep 10 years worth of data using SQL Server. I would like to keep two years online and backup the other eight years. What are some techniques to do this?   Software/Hardware used: SQL Server

Database restore

I'm struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the db to a point in...

MySQL database size

Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance? Software/Hardware used: linux server

Converting SQL 7 Database to Excel

Hi, I would like to know any possible way of converting my Sql 7 Database to Excel formats. Any ideas anyone. Thanks

Auditing Windows 2003 and MS SQL 2005

Are there any audit scripts I can use to audit Windows 2003 and MS SQL 2005?

Is having the auto create statistics on in a database a good thing?

Hello I have a 250GB database and the auto create statistics is on is that a good thing? Software/Hardware used: sql server 2005

Replication sync_method set to concurrent in SQL Server 2000

Hi, Just wondering what happens to data that are inserted during the time of a snapshot replication generation when the sync_method is set to concurrent, as there are no table locks, are the data insert into the publisher then held in the distribution database and when the snapshot has been...

STORED PROCEDURE

Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it   Software/Hardware used: AS/400 sql400 DB2

MS Exchange on Server 2000 one user can receive but not send mail

One of my users reported that he is not able to send e-mail from his Outlook client.  I sent test messages from his Outlook client to both an internal and external address and did not receive eitehr message.  I sent him e-mail from both my internal and external e-mail addresses and they went...

The most-watched IT questions this week: Oct. 20, 2009

Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

Set identity to not for replication in T-SQL

Hi, Does anyone know the TSQL to change the identity column on a table in SQL Server 2000. And also the TSQL to change trigger to not for replication. Thanks

Five t-shirts to give away: Upload those profile pictures!

I've been noticing a dropoff in profile pictures lately -- here's a reminder on how to upload yours if you haven't already. If you're participating in the community, we want to know who you are! I'll be mailing out five t-shirts to the first five people (with eligible mailing addresses) to upload...

Grant users rights to run reports on reporting services

How do I grant users rights to run reports on reporting services?  Those with admin access can run them, but users without admin access can't - they get an error that they don't have access to the data source.  When setting up the source, we used windows authentication.  I've given clearance on...

store image to sql server

would you please give me a code to store and retrieve an image in SQL Server 2000, using Visual Basic 6.0 on the front end Software/Hardware used: vb6