Find the SQL value behind the decimal
I need to know if the numbers after a decimal point are greater than 0. What is the easiest SQL syntax to do this?

Answer Question   |  June 24, 2010  8:42 PM
SQL, SQL Query, SQL Syntax

Can anyone tell me the best way to query Active Directory in SQL?
Can anyone tell me the best way to query Active Directory in SQL? I’m using SQL Server Management Studio Express and want to add the LDAP server for AD as a linked server to query. I’m not sure what the best way to do this is.

Answer Question   |  June 22, 2010  12:15 PM
Active Directory, Active Directory query, LDAP, SQL Server 2005, SQL Server Management Studio 2005, T/SQL

Users accessing SQL Server 2008 database
how can i know how many users are accessing database remotely and how much load is on database .how can it be detected in sql server 2008. pls let me know .  

Answer Question   |  June 25, 2010  11:55 AM
SQL Server, SQL Server 2008, SQL Server User Accounts

Converting from RPGLE to DB2/400 SQL
My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

Answer Question   |  June 22, 2010  8:30 PM
DB2/400, RPGLE, SQL, SQL migration

SQL Server 2005: Improving performance of Multiple Databases & LUNS
I am looking at ways to improve performance of our databases. We have 4 large databases (ranging between 50gb and 200gb each) on a single SQL Server 2005 Cluster. Currently they are split 2 on one LUN and 2 on another. I am looking at ways to improve the IO performance of the databases as [...]

Answer Question   |  June 22, 2010  5:25 PM
Cluster management, LUN, RAID 10, SQL Server 2005, SQL Server clustering, SQL Server performance, Storage in 2010

trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.
We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What’s the “condition” selected and how’s the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any action?? SQL Database [...]

Answer Question   |  November 24, 2010  7:58 PM
MAC address, Radius Server, SQL Query, SQL Server 2008, Windows networking, Windows Server 2008

Bulk Insert Problem in SQL Server Management Studio 2005
Hi. I’m running into an issue performing a bulk insert. I’ve taken the following steps: Created a table Created a schema file with a .fmt extension Created a stored procedure to insert a file When I attempt the bulk insert I get the following error message: Cannot bulk load because the file “g:USB06182010.txt” could not [...]

Answer Question   |  June 21, 2010  3:46 PM
SQL INSERT, SQL Server Management Studio 2005, T/SQL

SQL Query for Price Data of Different Stocks from 1 table with same dates
I am having 1 table with date, stock and price data for all stocks. I want a sql query which will display the date, stockname1, stockname2, stockprice1 and stockprice2 for the 2 stocks I mention and the date range I mention and date should be common to both stocks. If stock1 has a price on [...]

Answer Question   |  June 17, 2010  7:58 AM
SQL Express, SQL Express 2005, SQL Query, SQL Server

SQL 2000 migration to SQL 2005 – need to preserve user security
Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an “orphaned” database.  Our app stops working if a database is simply detached/attached to another server because it loses that [...]

Answer Question   |  June 17, 2010  2:24 PM
SQL Database Security, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server security, SQL Server Upgrade

New Contest: You Could Win a New Xbox 360
Now is the time to ask and answer questions on ITKnowledgeExchange.com because you could take home a newly released Xbox 360. From today (June 16th) through July 30th, you have a chance to win 1 of 2 Xbox 360s or 1 of 3 $50 Amazon Gift Cards. The five community members who have the most [...]

Answer Question   |  August 5, 2010  2:14 PM
DataCenter, DataManagement, Development, Exchange, ITKE Community, ITKE Contests, ITKE Feedback, ITKnowledgeExchange, Linux, Lotus Domino, Microsoft Windows, Mobile, SQL Server, VoIP

Database backup terminating abnormally
m running this code for backing up and to have backup log backup database adventureworks to disk = ‘g:radvent6.bak’ mirror to disk=’g:radvent7.bak’ with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values(‘dreee’,'reserch’) backup log adventureworks to disk=’g:radvent6.trn’ after the backup log command executes shows the error as The statement BACKUP LOG is not allowed while the recovery [...]

Answer Question   |  April 11, 2011  12:38 PM
Backup, Database Backup, SQL Server 2008

Using Report Server in SharePoint 2010
In SharePoint Integrated Mode of SSRS 2008, how do you get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods? This question is from the Microsoft Live Chat which took place on June 1st.

Answer Question   |  March 2, 2012  8:15 PM
Report Server, ReportService 2006, Sharepoint 2010, SSRS 2008

Improve performance on Insert rows into DB2 400 table from SQL server
Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for [...]

Answer Question   |  October 29, 2010  2:58 PM
AS/400, DB2/400, Linked servers, SQL Server, SQL Server 2005

Documentum Stops Processing
During import of Excel files, documentum just stops processing & disappears. There’s nothing in the log, other than 49 files were processed & no errors. EMC cannot duplicate the error in their lab. Installation gone awry? CC me at morgans@southcoastplaza.com with solution.

Answer Question   |  June 15, 2010  10:32 PM
Documentum, EMC Documentum, Excel import/export, SQL 2008

Compare Two Tables With Identical Fields
Need to compare two tables A & B with identical fields and report when rows don’t match and rows from B are missing in A.

Answer Question   |  June 15, 2010  7:46 PM
SQL, SQL tables

How to split a column into SQL data..
I have table called  country having one column called complete_name (varchar(max)) which is as under   [table style="border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0"> [tbody] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" width="590"> [strong]complete_name[/strong] [/td] [/tr] [tr] [td style="border: medium none #d4d0c8; padding: 0in 5.4pt; background-color: transparent; width: 6.15in;" valign="top" [...]

Answer Question   |  June 24, 2010  4:09 PM
SQL Server 2005, SQL Server tables, T-SQL

SQL Recovery from MDF and LDF – Missing Data
Where to start … On 6/2 we lost a major system that we found relies on a database that hasn’t been backed up since 5/7. We lost 3 of 4 HDD in a RAID5 array. We sent the drives to a recovery firm and they have recovered all of the data. However, the timestamp on [...]

Answer Question   |  October 5, 2011  2:10 PM
LDF, MDF, SQL 2000, SQL Server 2000, SQL Server backup, SQL Server backup and restore

SQL Query for Time Filed
I have a sql table where the field tr_time contains the trade time and datatype of the filed is Datetime. I want to retrieve records where the time is in multiple of 5 seconds, so records where the seconds are in multiple of 5 only. How can I do this?

Answer Question   |  June 14, 2010  8:28 AM
SQL Query, SQL Server 2005, SQL tables

Inserting DB2 records on iSeries to SQL Server 2005 Table
I need to insert records from a DB2 file residing on an iSeries to a SQL Server 2005 table on a remote system. How can I do this in a CL or RPG ? Thanks

Answer Question   |  June 20, 2011  12:27 AM
DB2, iSeries, SQL Server 2005

SQL Server table structure
Hi, i want to know is there any command other than SP_help or SP_columns to see the STRUCTURE of TABLE.

Answer Question   |  June 16, 2010  4:05 AM
SQL commands, SQL Server, SQL Server tables