If I issue: SELECT CAST(CAST('2000-05-08 12:36:29.998' AS datetime) AS bigint) AS Expr1 I get 36653 as the result. If I issue: SELECT CAST(CAST('2000-05-08 12:35:29.998' AS datetime) AS bigint) AS Expr1 I get the same result even though the times differ by one minute. Can a...more >>

This question involves two distinct databases in SQL Server 2000. I have to create a trigger (for update and insert) which selects some rows from a table in *another* database. The problem is that when a domain user in DB#1 tries updates a row in this table and the trigger fires, SQL Server...more >>

Hi, I am using MSDE2000 sp4 and tried following: (you can copy it directly in QueryAnalizer) ----------------------------------------------------- declare @tbl table ( yyyymm int, id int, x int ) -- insert into @tbl values(200502,1,0) insert into @tbl values(200502,2,0)...more >>

Hello All: From the Following Table, I want to enter a Temperature and then have the SQL Function Return the Web Color -- TemperatureIndex -- ID TempMin TempMax WebColor 1 0 9 #E59DCB 2 10 19 #8569FA 3 20 29...more >>

I'm know that for composite indexes, the recommendation is always to specify the most selective column first, but can someone please explain why this makes such a huge difference in perfomance?? I have a table where column A only has 1 unique value and column B is basically unique among all r...more >>

I need to delete invalid records in child table while parent have 2 Fields PrimaryKey like this ================================== Delete From AH_TasnFakaraat Where Master_ID,Fakra_ID not in (Select Master_ID, Fakra_ID From SubMaster) ============================== (,) is not acceptable ...more >>

I have Changed my database schema and transform Data with new keys using this Query : SELECT Case_No, Case_Date, Ma7akem_ID, COUNT(*) AS Expr1 FROM Master_Ahkam GROUP BY Case_No, Case_Date, Ma7akem_ID HAVING (COUNT(*) > 1) Due to a Design error in the old one there was a ...more >>

In the past, I've always used "int" for the Identity field. But as the application usage increases, it seems to demand for values that exceed the "int" scope. I'm thinking of upgrading all my Primary Keys that were "Int" to "BigInt". I'd like to know if there's any performance degradation by...more >>

There is a file in my c:\winnt\system32 by the name sysfile.log, and it contains what seem to be the queries a reporting tool uses, and its filling up on disk space real fast, is anyone aware of this problem please help..asap ...more >>

Hi Can somebody please point me to good URL or may be some scripts that I can use to execute as part of DB health check. Also, I would like to see if the DB is well designed or thought of while it was created; I know its a wide subject, but I will be happy to get started with some script t...more >>

Hi It would SEEM to me that this is a rather neat way to write SPs Create proc mysp @LastName varchar(32) = NULL @Date datetime As Select Fieldlist from tblOrders where TranDate > @Date and ( @Lastname is null or name = @LastName) i..e if @Lastname is provided then f...more >>

Hello: I need to import an Excel file to SQL Server. The .xls file has the column names which contains dot inside, like AAA.BBB. When I import this file in SQL using DTS Import/Export tool, it creates a table with column names like AAA#BBB. So, during import process the dots substitutes with #...more >>

Hi, My appln runs on a remote server. A few minutes ago i accidently ran a 'Truncate table' command. Is there anyway to recover it thru Query Analyzer. The DB Recovery model is SIMPLE and i have the dbOwner permission. Thanking in Advance Lara ...more >>