SQL Server Disk Alignment
What size should I set the Starting Partition Offset on the disks when running sql server 2005 32-bit enterprise edition, shuld it be 1024KB or 64KB?

Answer Question   |  January 12, 2011  5:55 PM
SQL 2005, SQL Server, SQL Server 2005, Windows Server 2003, Windows Server 2003 32-bit

Alter proc to fetch a table structure from SQL Server 2005 database
hi please segest me… what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N’?') begin print N” print N’Usage: sp_table_struct @tablename, @flags int = 0′ print N’ where [...]

Answer Question   |  January 7, 2011  9:59 AM
FETCH statement, SQL 2005, SQL 2005 Database, SQL Server 2005, SQL Server tables

SQL Server Plan Cache
There is a bucket in plan cache with 75 objects in it and it is the same sql statement. Other than using DBCC FREEPROCCACHE what will clear out the cache? Restarting SQL SERVER Service? I use the code below to look up how many plans are in a bucket. SELECT   bucketid,   entries_in_bucket = [...]

Answer Question   |  December 29, 2010  11:30 PM
Cache, Cache Mode, SQL, SQL 2005, SQL performance, SQL Server

SQL Server 2005 with SAN storage problem
i have a very strange problem: - i have an  windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann’t [...]

Answer Question   |  December 20, 2010  10:20 AM
SAN, SAN storage, SQL 2005, SQL Server 2005

SQL I/O Best Practice
I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?

Answer Question   |  December 20, 2010  10:11 PM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003

Question on SQL 2005 table
tablename:-software pname             packagename                    cost MARY               README                             1200 ANAND             PARACHUTES                     6000 ANAND             VIDEO TITLING                   16000 JULIANA           INVENTORY                        3500 KAMALA           PAYROLL PKG                    20000 MARY                FINANCIAL ACCT             85000 MARY               CODE GENERATOR          20000 PATTRICK        README                            1200 QADIR               BOMBS AWAY                 3000 QADIR               VACCINES                      3100 RAMESH             HOTEL MGMT                35000 RAMESH               DEAD LEE                    4500 REMITHA              PC UTILITIES                5000 REMITHA               TSR HELP PKG             6000 REVATHI             [...]

Answer Question   |  December 11, 2010  8:39 PM
SQL 2005, SQL Server 2005, SQL Server tables, SQL tables

SQL Server 2005 procedure to Create stored procedure
sir,plz tell me the procedure from strating that how to create stored procedure

Answer Question   |  December 11, 2010  11:19 AM
SQL 2005, SQL Server 2005, SQL Server stored procedures, SQL stored procedures

SQL Server 2005 License
This question is not about doing something illegal toward the SQL Server Licensing; on the other hand it is about knowing relationship between Licensing and hardware. Question: I have SQL Server 2005 licensed for 2 physical CPUs. Recently, I bought a system with 4 CPUs to replace the old machine. I know that I must [...]

Answer Question   |  November 20, 2010  8:55 PM
CAL, CPU, SQL 2005, SQL Server 2005 License, SQL Server licensing, Windows Server 2003

Is it safe to delete SQL Server Transaction Log?
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]

Answer Question   |  November 18, 2010  11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003

Filename from SQL 2005 Query
I have a batch file that runs a SQL query command overnight once a week and outputs the results of that query to a file as a .csv file. The query produces, amongst other things, a week ending date. Is it possible to to name the output file with result of the week ending column [...]

Answer Question   |  November 12, 2010  12:56 PM
Batch files, SQL 2005, SQL Query, SQL Server, SQL Server 2005

SQL SERVER SAN Setup
I do not know much about SAN’s, I want to setup a SQL Server to use a SAN. 1. Should I use a SAN drive to install the OS or is it best practice to install the OS on a local drive on the server? 2. Should I install SQL SERVER on the SAN or on a [...]

Answer Question   |  November 15, 2010  9:15 PM
SAN, SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server 2005 (32-bit)

Migrating from Windows server 2003 32-bit to Windows Server 2008 64-bit
We are migrating from Windows server 2003 32bit to 2008 64 bit. What should we be aware of before progressing? What pitfalls or incompatibilities should we be prepared for? The server is an Active Directory box running SQL 2005.

Answer Question   |  November 3, 2010  2:22 PM
Active Directory, SQL 2005, Windows Server 2003, Windows Server 2003 32-bit, Windows Server 2008, Windows Server 2008 64-bit, Windows Server Migrations and Upgrades, Windows Server Upgrades

Documenting stored procedure jobs in SQL 2005 enterprise
Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

Answer Question   |  November 1, 2010  2:19 PM
SQL 2005, SQL procedure, SQL Server 2005, SQL Server 2005 Enterprise Edition, Stored Procedures, Windows Server 2008

Extracting in SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG                                                        IL 60195 I NEED TO EXTRACT APT 120  INTO ANOTHER LINE LIKE APT 120                                                                      1065 VALLEY LANE                                                                       SCHAUMBURG                                                                        IL 60195

Answer Question   |  October 27, 2010  1:17 PM
EXTRACT, Field-Level keywords, SQL 2005, SQL 2005 Database, SQL Server 2005

SQL Server 2005 Memory
I have a server with 8 dual core processors, 32GB of RAM, windows server 2003 32bit, sql server 2005 enterprise, and a 500GB database running on it. 1. How does sql server use memory in this case? 2. I have heard from sql server pro’s that sql server can only use 4GB of RAM is that [...]

Answer Question   |  October 26, 2010  1:54 PM
SQL, SQL 2005, SQL Server, SQL Server 2005, SQL Server memory

How do I modify stored procedures in sql 2005?
Where can I view in SQL 2005 when a stored procedure was run and what its outcome was? Can I see who ran it? Can I see who modified the job?

Answer Question   |  October 23, 2010  5:28 PM
SQL 2005, SQL stored procedures

SQL Server Profiler
What numbers are considered high when using sql server profiler for reads, writes, and duration

Answer Question   |  October 8, 2010  10:00 PM
SQL, SQL 2005, sql 2005 Performance Issues, SQL Profiler, SQL Server, SQL Server 2005

SQL Server 2005 Express
Hi, Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation? I know it is probably a good idea to atleast change the autogrowth setting from 1MB but what about [...]

Answer Question   |  October 2, 2010  6:29 AM
SQL 2005, SQL Jobs, SQL Server 2005, SQL Server 2005 Express, SQL Server Express

Migrate MYSql database to SQL 2005
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?

Answer Question   |  September 21, 2010  3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows

Avoid duplicate entry in database through Visual Basic 2005
I have made a program in VB 2005 with SQL2005 as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.

Answer Question   |  September 20, 2010  10:29 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005