Tuning SQL query with hierarchy result through DB link
I have the below SQL query: /********************************************************************************************************/ SELECT tm_super.tm_nbr ,tm_super.tm_fname ,tm_super.tm_lname ,tm_super.super_tm_nbr ,tm_super.super_fname ,tm_super.super_lname ,tm_super.super_job FROM (SELECT papftm.employee_number tm_nbr ,paaftm.supervisor_id tm_super_id ,paaftm.person_id tm_person_id ,papftm.first_name tm_fname ,papftm.last_name tm_lname ,papfsuper.employee_number super_tm_nbr ,papfsuper.first_name super_fname ,papfsuper.last_name super_lname ,UPPER(pjsuper.name) super_job FROM per_all_assignments_f paaftm ,per_all_people_f papftm ,per_all_people_f papfsuper ,per_all_assignments_f paafsuper ,per_jobs_v pjsuper WHERE papftm.person_id = paaftm.person_id AND paaftm.supervisor_id = papfsuper.person_id AND [...]

Answer Question   |  August 11, 2009  7:22 AM
DBLink, SQL tuning

Display Bug with CFTextArea?
Is there a bug or a trick needed for cftextarea to display DB retrieved query data? When I try to display a single retrieved MS-SQL varchar value in a cfwindow dynamically created form, I must refresh to see the value. A HTML textarea control on the same form displays properly. Multiple query rows display fine [...]

Answer Question   |  August 7, 2009  5:02 PM
SQL, SQL Database, SQL Display

Adding data in SQL 2005 server
i am trying to add data on an sql database from backend problem is it does not acceptnull values kindly help. My email address is edmuia@yahoo.com

Answer Question   |  August 6, 2009  2:00 PM
SQL Server 2005, SQL Server database

view active directory data using SQL server 2005
How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot for [...]

Answer Question   |  April 13, 2010  11:25 AM
Active Directory, SQL Server 2005

SQL Server 2005 – Unable to Eun a Pull Subscription due to “unable to connect to distributor” error
I have 2 Windows server (Windows Server 2003) running SQL Server 2005. Server 1 is the distirbutor and publisher. For a snap-shot replication, I have no problems running a push subscription from server 1 to server 2. However when I try to set up and run a pull subscription on server 2. It fails due [...]

Answer Question   |  August 17, 2009  9:37 AM
SQL Server 2005, SQL Server replication

Changing the sql server service and agent windows account password
Hello, we are considering changing the sql server service and agent’s password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

Answer Question   |  August 5, 2009  4:09 PM
SQL Server Agent, SQL Server authentication, SQL Server security, SQL Server Services

SQL Server 2005 question self join query
I have one table that name is TblCategory on that 2 columns are CategoryName another column name is UpperCategoryID my table is like this CategoryName UpperCatID ———— ———– Book Commerce Commerce Accounting Science Math Commerce B.O. Material Pen Pen Link Pen Renolods I want ouput like CategoryName ———— Book Material

Answer Question   |  August 5, 2009  10:36 AM
SQL Server 2005, SQL Server Query, SQL Server tables

Exporting SSRS Report in Simple Excel sheet(not formatted)
Hi All, when I export and ssrs report in excel, it gets exported in excel but in a fancy format. I want to export the data in a simple excel sheet format so that I could apply filters or formulaes. If any one of you are aware of this do let me know please. Avhilash.

Answer Question   |  August 5, 2009  10:11 AM
Export SSRS Report to Excel, SQL Server Reporting Services, SSRS, SSRS 2005, SSRS reports

SQL Server 2008: Difficulty setting mixed mode authentication password
I am attempting to install SQL Server 2008 (64-bit) on Windows Server 2003 SP2 (64-bit). During the installation, I get stuck at the step where it asks for a mixed mode authentication password. Following the requirements, I have tried a strong password but I am still getting the error message, “The specified SA password does [...]

Answer Question   |  August 4, 2009  6:31 PM
SQL Server 2008, SQL Server 2008 64-bit, SQL Server authentication, SQL Server installation, Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 R2 x64

SQL Select: Getting the previous records from a known record
I issued a select statement like this: Select phone# from pltlcd where phone# >= 985143525 fetch first 20 records only PLTLCD is a file sorted by phone#. From the first record retrieved by the aboe select statement, how do I get the 20 records in the file that exist before the returned set of the [...]

Answer Question   |  February 29, 2012  4:37 PM
SELECT statement, SQL Select, SQL Select statement problem

Encrypt the password in SQL 2000
How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to pass the encrpted [...]

Answer Question   |  August 4, 2009  11:53 AM
ASP, SQL Server 2000, SQL Server encryption, SQL Server security, VB

Estimate SQL Server tempdb space for a query
Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns [...]

Answer Question   |  August 3, 2009  7:46 PM
Space allocation, SQL Server, SQL Server Data Storage, TempDB

Recovering lost SQL Server 2000 data
I lost a LDF file for SQL server 2000 — but I have the MDF. How can I recover my data?

Answer Question   |  December 13, 2010  6:47 PM
Data Recovery, LDF, MDF, SQL Server 2000, SQL Server backup and restore

Error during SQL Server 2000 installation
When I attempt to install SQL Server 2000 using Windows XP Service Pack 2 for IT Professionals and Developers, I encounter the following error: “Microsoft SQL Server 2000 Enterprise Edition server component is not supported on this operating system. Only client components will be available for installation” How can I fix this problem?

Answer Question   |  September 7, 2010  6:43 PM
SQL Server 2000, SQL Server error messages, SQL Server installation

unable to connect to SQL from Access
I want to create a new database on SQL Server 2008 from Access 2007. I had no problem before I updated to vista from XP professional. When I test the connection, no problem, however when I try to create the database I get the message: The new database wizard does not work with the version [...]

Answer Question   |  August 3, 2009  6:10 PM
Access 2007, Microsoft Access, SQL Server 2008, SQL Server to Microsoft Access

Filling data in datagridview in vs2005 with windows develpment
HI all I have a more than 80000 data in sql server 2008 in a single table. Then i have to show that data in datagridview. But the performance has very slow some time my machine hang. It has taking several minute. So i have to improve this performance could anybody help me. For information [...]

Answer Question   |  August 10, 2009  6:56 AM
DataGridView, SQL Server 2008, VB.NET, VB.NET 2005, Visual Studio 2005

SQL Server tables – What account created the object
Is there a way to see who created or droped a table in sql server?

Answer Question   |  August 3, 2009  11:33 PM
SQL Server administration, SQL Server tables

Refresh/Run SQL
We upgraded to Crystal Reports 2008. Our older version queries appear to work… In the Older Verion all we did is click the lightening blot. Now… we have to go through Database, SQL to run/refresh the query. Isn’t there a one click key for to run these queries?

Answer Question   |  August 3, 2009  9:28 PM
Crystal Reports, Crystal Reports 2008, SQL, SQL Database

Memory overhead recommended for benchmarking SQL server 2005 on vSphere
For a ‘direct’ physical to VM comparison of SQL server 2005, would anyone recommend giving the VM extra (say, 1.5GB) RAM to compensate for any overhead the OS needs? So a direct comparison would then be 1vCPU, 2.5GB RAM VM & SQL set to use 1GB RAM) vs. SQL on physical host set to use [...]

Answer Question   |  July 31, 2009  8:09 PM
Physical hosts, SQL Server 2005, SQL Server memory, Virtual Machines, vSphere

SQL Server: Index and Key
What is the difference between a key and an index? Whe I issue a SELECT statement, and the table has an index, do I still have to use my key?

Answer Question   |  August 3, 2009  5:08 PM
Index and Key, SELECT statement