Viewing 15 posts - 4,786 through 4,800 (of 5,393 total)
Just pray that your employer doesn't come across this thread.
Good luck.
BTW, I will remember your name and never help you in these forums, because I don't think that this is...
-- Gianluca Sartori
October 8, 2009 at 2:42 am
delete from ReportDetailTable
where ReportDetailTableID in (Some SubQuery, not to complex)
If the cost of the query is on the delete step, there isn't much you can do.
You could drop and re-create...
-- Gianluca Sartori
October 8, 2009 at 1:50 am
SQL Server works great with Java. You just have to pick the right JDBC driver.
I have used JTDS and MSJDBC and they both perform well. Unfortunately they don't behave identically,...
-- Gianluca Sartori
October 8, 2009 at 1:19 am
You should get rid of the NOLOCK hint, both from the view and the query.
NOLOCK could return inconsitent results (eg. when a page spilt is involved).
You can use it safely...
-- Gianluca Sartori
October 8, 2009 at 1:10 am
ZA_Crafty (10/8/2009)
Is this due to the fact that it deletes row by row and writing to the log file, or can it be something else?
With row by row, you...
-- Gianluca Sartori
October 8, 2009 at 1:08 am
You sigh, but Paul's reply made me laugh!:hehe:
-- Gianluca Sartori
October 6, 2009 at 3:38 am
Steve Jones - Editor (10/5/2009)
I think I am paying about 1/2 the cost of hiring someone and getting it done as well.
Well, this works when you wouldn't be earning more...
-- Gianluca Sartori
October 5, 2009 at 9:45 am
Gianluca Sartori (10/2/2009)
Non c'è niente che possa sostituire la pratica. L'importante è capire cosa...
-- Gianluca Sartori
October 2, 2009 at 6:47 am
Ti suggerirei di comprare un buon libro e di fare un bel po' di pratica sul campo.
Non c'è niente che possa sostituire la pratica. L'importante è capire cosa succede a...
-- Gianluca Sartori
October 2, 2009 at 6:33 am
You could use the command line switches of SSMS/SQLWB
Ssms.exe|SQLWB.exe [-S servername] [-d databasename] [-U login] [-P password] [-E] [-nosplash] [file_name[,file_name]]
-S [servername] server name to connect to
-d [databasename] nome of the...
-- Gianluca Sartori
October 2, 2009 at 6:10 am
Still can't find anything wrong.
I suggest you try a SELECT first, so you can identify what's wrong.
SELECT stypc.*, spd.*,
newFlag = CASE WHEN spd.page_detail_id = 202
...
-- Gianluca Sartori
October 1, 2009 at 2:54 am
You could use something similar to this:
DECLARE @rwcnt int
DECLARE @BATCHSIZE int
SET @rwcnt = -1
SET @BATCHSIZE = 100
WHILE @rwcnt <> 0
BEGIN
SET ROWCOUNT @BATCHSIZE
UPDATE VeryLargeTable
SET varbinaryColumn = NULL
WHERE documenttypeid IN (4,...
-- Gianluca Sartori
October 1, 2009 at 2:37 am
I don't understand your problem. It's working on my test data.
DECLARE @Survey_Thank_You_Page_Config TABLE (
acct_id int,
survey_stub uniqueidentifier,
allow_invitation_forward_flag bit
)
DECLARE @Survey_Page_Detail TABLE (
acct_id int,
survey_stub uniqueidentifier,
page_detail_value int,
page_detail_id int
)
INSERT INTO @Survey_Thank_You_Page_Config (acct_id, survey_stub) SELECT
1, '57F2E213-BC6B-48CA-B025-1597688A8F96'...
-- Gianluca Sartori
October 1, 2009 at 2:24 am
Maria, thanks for posting your code.
The cursor based solution works well and reliably, but could become too slow when the table becomes really large. Cursor based solutions don't scale well,...
-- Gianluca Sartori
September 30, 2009 at 3:40 pm
Viewing 15 posts - 4,786 through 4,800 (of 5,393 total)