Still learning so bear with me 1) Say I have a complicated select query (many joins) that I'd like users to run. Which typically performs better and why: creating a view with the select query or creating a stored procedure with the select query. Assume users don't care which mechanism is ...more >>

hi dis is kalaivanan, which one of inner join or left join is efficient and in what way. ...more >>

If I were to copy a database from one machine to another machine, I can use: - Backup & restore - Detach & attach Not to mention on those daily backup or availability of the database. Just consider copy one database to another machine. Does anyone know what's the advantage of each method m...more >>

Maybe my question is too simple because I dont know much of RAID, but I try: What is probably "better": One RAID of 4 Disks, where datafile and logfile are placed on, or Two RAIDs of each 2 Disks, where one RAID contains the datafile and the other RAID contains the logfile? Joachim...more >>

Hi Anyone out there had bad experiences with SQL Server 2005 and Access 2002/2003 ADE's? Look forward to hearing your comments, as I have been asked to deploy our shrink-wrapped ADE on a SQL Server 2005 backend.... TIA ...more >>

I'm trying to set up mirroring on sql2005 and I'm having problems with the 'alter table set partner' command. ALTER DATABASE testdb SET PARTNER = N'TCP://dbserver2:5022' I'm running on a workgroup, so I don't have a domain name, but I get this: Msg 1418, Level 16, State 1, Line 1 The ser...more >>

Hello, Is there a way to change the collation of a sql2000 from Latin1_General_CS_AI to Latin1_General_CI_AI? thanks Wilfrid ...more >>

How can SET options, such as ansi_defaults, ansi_null_dflt_on, ansi_nulls, ansi_padding, ansi_warnings, concat_null_yields_null, date_first, date_format, deadlock_priority, language, lock_timeout, quoted_identifier arithabort, and transaction_isolation_level, used in sys.dm_exec_requests, be of v...more >>

I'm trying to play with SQL Server Management Studio version 9.00.1399.00 and I have to wonder if it's stable enough for production work. I'm having way too many problems that seem like bugs. I have encountered the message "Ad hoc update to system catalogs is not supported" several times w...more >>

Hi Can we figure it out whether or not SQL Critical Update Kit package is installed or not on the SQL Server http://www.microsoft.com/downloads/details.aspx?familyid=9552d43b-04eb-4af9-9e24-6cde4d933600&displaylang=en Thks ...more >>

HI, I thought I read somewhere about a Stored Procedure that can be used to change all objects owned by x to owned by y. Does anyone know of such SP, tell me about it, please. OR Tell me a better way of changing ownership of ALL (DTS, Jobs, anything that has sa and the sa PW assigned to it)...more >>

I am reading the Microsoft article 'Statistical maintenance functionality (autostats) in SQL Server' (http://support.microsoft.com/kb/q195565/) and I'm wondering about this part: "NOTE: In addition to cardinality, the selectivity of the predicate also affects AutoStats generation. This means ...more >>

SQL2K5 SP1 I am testing out Synchronous Mirroring and have a question about failover. It seems the only way I can failover to the Mirror box is to log onto the Principal box and hit the Failover button? Isn't the whole point of mirroring to be able to handle the Principal not being available?...more >>

I'm having a security problem with linked servers on a SQL Server 2005 box. All server boxes are running Windows Server 2003. The SQL Server 2005 box is the only one running x64 Windows and x64 SQL Server. All logins in all contexts are being done with my AD domain account. I create a li...more >>

I have a host with 4 processors I checked the server properties of SQL Sever and it is authorized to use all of them but still sometimes when I run long batch processes the first processor goes to 100% and the others remain almost idle. Any idea of what might be wrong? ...more >>

What settings need to be applied to a Login for them to be able to manage Jobs?? SQL2000sp4, I am trying to clean up security issues and provide only those rights needed. Before this everyone was attached to System Administrator. ...more >>

How can I move my SQL Server 2005 templates from server to server? In SQL Server 2000 they were all stored in *.tql files on the hard drive at C:\Program Files\Microsoft SQL Server\80\Tools\Templates\SQL Query Analyzer. But in SQL Server 2005 it appears that I can't access the template files...more >>

I am trying to get a subscription to automatically send out an email to an address outside of our company. It is giving me an error that says "The e-mail address of one or more recipients is not valid." I do not have a problem sending to addresses inside the company. Anyone have any ideas. ...more >>

Hi, I have problem with SQL 2005 and SQL 2000, I did install SQL 2005 as a defaulf instance and SQL 2000 server as a name inctance on the same serverbut now when I try to start SQL 2005 I get this Error: An error has occurred while establishing a connection to the server. When connecti...more >>

My backups have been successful until last week. I am suddenly getting the message telling me there is not enough space on the disk. The disk has 215gb of free space. I am backing up to an external firewire hardrive. I can successfully do a backup to the same disk as the database. I do a di...more >>

Is there a view or something that lets you see what recovery mode your db is set to? I'm trying to tidy up a stored procedure that does a backup of all the trans logs, but I get an error when it hits a db set to Simple. Thx. ...more >>

I have a table in an SQL server 2005 database that has 4million plus records. When I try to add a primary key to this table using the Management studio I get an error message telling me that it was Unable to create index and that a timeout had expired. I know adding a key to a table of this s...more >>

I've been playing around with new asp.net 2.0 membershp functionality. I was able to build a simple login form that secures a directory on a project I built locally on my development desktop. However, when I attempt to follow the same steps on the remote test server (a website I access via f...more >>

We have just bought a new box for our SQL Database's.. ..We have three database's, 1 is by far the most intensive, it's a 3rd party application database and is around 20gb.. ..it uses the temp db heavily.. ..and the transaction log gets up to about 750mb - 1gb before it's backed up every 1...more >>

Hi I am facing a big problem. please help. We r having SQL Server 2000 Enterprise. I have 3 triggers (FOR type) on a Table1 on each action - insert, update & delete. These triggers are inserting the audit for these actions into another Table2. Table2 has an identity column which increment...more >>

Why this query, that have a left outer join, generate a query plan with a inner join. I don´t undertand. the results get by the query are a inner not a left join. I attach the query and the query plan. THe query select c.codigoproducto,d.codigoproducto from componentes c l...more >>

I'm running the same insert 'insert into jftemp values ('2006/09/11')' on 2 different servers, one saves this date as 11th Sep the other saves it as 9th Nov. Both servers have the same regional settings, language settings, default language - both are SQL Server 2000 (SP4). Can someone suggest ...more >>

Hi all, we can read in many articles that page splits don't occur with a cluster on a monotone increasing column (like an identity column) . with this script, we don't see that : with a clustered idendity column, the performance monitor shows page splits ( "SQLServer:AccessMethods" ; "Pag...more >>

Hi group I want to copy a DB from one Sql Server 2000 SP3 to antother Sql 2000 Sp3. I´m using the DTS Import agent in Enterprise manager. After a few minutes I´ve got an error Message telling me that the copy process failed. The Log file of the Enterprise Manager is empty. Any Idea what happen...more >>

I setup a VD using "VD Managment for SQLXML 3.0", changed VD to ASP.2.0 and now get this error on my login page (can someone help ?) Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific ...more >>