SQLQuest29

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 286 total)

RE: lots of CXPACKET wait types

Matthew Darwin (3/15/2012)
The problem looks to be the predicate for your scan is using CONVERT_IMPLICIT for your dealer_id and account_no.
I'm guessing this is being caused by the difference in collation...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 15, 2012 at 12:22 pm

#1460083
RE: PLE

Admingod (3/6/2012)
Actually server is 2005 32 bit enterprise and Windows server is 2003 SP2 enterprise(my understanding is 32 bit enterprise will take max memory of OS without need to enable...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 7, 2012 at 2:16 pm

#1456250
RE: PLE

Admingod (3/6/2012)
Actually server is 2005 32 bit enterprise and Windows server is 2003 SP2 enterprise(my understanding is 32 bit enterprise will take max memory of OS without need to enable...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 7, 2012 at 2:16 pm

#1456249
RE: SQL Threading Error

atchristian (3/6/2012)
We have 48GBs of RAM and 38 of that is dedicated to SQL (nothing else runs but I wanted to leave some breathing room).
The processors are Xeon E5645...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 6, 2012 at 4:51 pm

#1455671
RE: SQL Threading Error

atchristian (3/6/2012)
Hello,
We recently built a new machine to host our SQL database. This new machine contains dual processors (our old machine was a single processor). Since we have made the...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 6, 2012 at 3:57 pm

#1455656
RE: Deadlocks are occuring

GilaMonster (2/27/2012)
Create a new nonclustered index (AllocatedByID, JobStateID) INCLUDE (JobID)
Should completely prevent the deadlocks.
This is what's can be called a key-lookup deadlock. The select takes a lock on the nonclustered...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 27, 2012 at 2:00 pm

#1452292
RE: Deadlocks are occuring

GilaMonster (2/27/2012)
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 27, 2012 at 1:20 pm

#1452269
RE: SQL Server 2012 SSIS – Sending files using FTP Task

We use psftp or curl .. they are free and does the job well.
Just use the script task in SSIS .. and get the job done 😀
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 23, 2012 at 2:53 pm

#1451115
RE: Log-shipping .. interesting question

anthony.green (2/23/2012)
you would want to bring the DB's online so you will have to issue a command to each DB with the WITH RECOVERY statement and then resolve any issues...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 23, 2012 at 8:55 am

#1450925
RE: Log-shipping .. interesting question

anthony.green (2/23/2012)
you would want to bring the DB's online so you will have to issue a command to each DB with the WITH RECOVERY statement and then resolve any issues...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 23, 2012 at 8:55 am

#1450924
RE: Log-shipping .. interesting question

20 per instance and 3 instance per server.
It will sound like a lot .. but the hardware is Dell R710 with plenty of memory and we have tested before implementing...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

February 23, 2012 at 7:46 am

#1450870
RE: Different ETL's deadlocking within SSIS package on Some days

sravani.sriram (1/23/2012)
These are deadlocks caused by your SQL query. Please modify your SQL queries using "with (NOLOCK)" to avoid deadlocks.
There is nothing to do with SSIS packages.
NOLOCK will result in...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 23, 2012 at 10:10 am

#1437218
RE: Different ETL's deadlocking within SSIS package on Some days

sravani.sriram (1/23/2012)
These are deadlocks caused by your SQL query. Please modify your SQL queries using "with (NOLOCK)" to avoid deadlocks.
There is nothing to do with SSIS packages.
NOLOCK will result in...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

January 23, 2012 at 10:10 am

#1437219
RE: Convert an interger to year month and days

Lowell (12/16/2011)
if the integer was something like 40891, we could infer that it was 40891 days since the beginning of SQL time, which would, by coincidence, be today (12/16/2011.
without a...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 16, 2011 at 3:02 pm

#1422744
RE: Convert an interger to year month and days

Thanks Lowel !
But my problem is that the data is integer and I get it as 465, 356, etc .. I need to convert it into meaning full data.
I guess...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

December 16, 2011 at 2:18 pm

#1422729

Viewing 15 posts - 61 through 75 (of 286 total)