Adi Cohn-120898

Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 1,479 total)

RE: Aggregate function SUM gives some junk value

Float is not an exact data type. If is an approximate data type. This means that it might have some mistakes but it should be few digits after...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 2, 2008 at 1:26 pm

#906483
RE: Load the data from XML file to Sql Server 2005 database

You can do it with the openrowset function and the provider bulk.
Here is an example:
create table #XmlTable (XmlCol xml)
go
insert into #XmlTable (xmlCol)
select BulkColumn
from openrowset(bulk 'c:\FileName.xml', single_blob) as dt
You can...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 1, 2008 at 4:04 am

#905454
RE: Log shipping in clustered SQL Server 2005

There is one difference that I remember. The definition of the network namefor the location to copy the backup files on the secondary server should be added as a...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 1, 2008 at 1:18 am

#905404
RE: Load the data from XML file to Sql Server 2005 database

Maybe there is a better way but I think that you’ll have to use dynamic SQL with Xquery. The Xquery part will get the values of the attributes and...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

December 1, 2008 at 12:55 am

#905401
RE: SQL Partitioning

amit (11/30/2008)
Yes you are right.
I am trying to move to different filegroups based on the partition key.
Thanks
A.
This has nothing to do with dropping the database. If you have only...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 30, 2008 at 12:49 am

#905214
RE: Cannot get value from SELECT statement

Johann Montfort (11/28/2008)
Hi All
this worked
SELECT @BuildID = BuildID
Adi can you tell me how I can do it with one delete and get a return value?
Thanks all!
You can use the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 28, 2008 at 5:05 am

#904717
RE: Cannot get value from SELECT statement

Johann Montfort (11/28/2008)
Hi All,
I am doing the following
SELECT BuildID AS [@BuildID]
FROM Builds_LIVE
WHERE BranchID = @BranchID
AND ProductID = @ProductID
--if found
IF @@ROWCOUNT > 0
BEGIN
DELETE FROM Builds_LIVE
WHERE BuildID = @BuildID
AND BranchID...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 28, 2008 at 4:31 am

#904688
RE: Deadlocks while updating rows in table

Might be wrong here but it seems that those 2 statements caused the deadlock:
UPDATE SS.SECTIONS WITH(ROWLOCK) SET SECTNO=160 WHERE ROOMNO=401
UPDATE SS.SECTIONS WITH(ROWLOCK) SET SECTNO=101 WHERE ROOMNO=601
Do you have an...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 28, 2008 at 12:04 am

#904592
RE: Deadlocks while updating rows in table

chris (11/27/2008)
UPDATE SS.SECTIONS WITH(ROWLOCK,HOLDLOCK) SET SECTNO=101 WHERE ROOMNO=601
This will indicate to the SQL engine that it must hold the lock on the rows it is updating till it has completed...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 28, 2008 at 12:01 am

#904591
RE: Deadlocks while updating rows in table

GilaMonster (11/27/2008)
Traceflag 1222 is preferred over 1204 on SQL 2005 as it provides a lot more info. 3605 is not required for logging deadlock info to the error log.
To get...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 27, 2008 at 1:38 am

#904173
RE: Deadlocks while updating rows in table

krayknot (11/26/2008)
TNV (11/26/2008)
Hi Kumar,
Basically I am new to this SQL Server stuff...
I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 26, 2008 at 11:45 pm

#904152
RE: if Full Backup Time and Trn Log Backup Time same?

Paresh Prajapati (11/26/2008)
So, as per ur side, we need to restore full backup first then restore all trn log backups up to point of time witch we have required up...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 26, 2008 at 11:34 pm

#904151
RE: Deadlocks while updating rows in table

TNV (11/26/2008)
Hi Kumar,
Basically I am new to this SQL Server stuff...
I am using MSSQL Server 2005 Express. I turned on trace by using DBCC TRACEON (1024). But in the errorlog,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 26, 2008 at 11:24 pm

#904149
RE: Restore Objects Only

2 Tim 3:16 (11/25/2008)
generate a script from the backup file? not sure how to do that. The reason I want to do this in the first place is...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 25, 2008 at 8:09 am

#903161
RE: Restore problem

Your are getting the error because you have a database with a different name then the database that you are restoring that has the same files' name and path as...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

November 25, 2008 at 5:57 am

#903049

Viewing 15 posts - 1,351 through 1,365 (of 1,479 total)