Forum Replies Created
Viewing 15 posts - 6,361 through 6,375 (of 7,471 total)
-
RE: What happens after UPDATE statement?
aha, the trigger issue
That's exactly the reason why one should always evaluate if a "procedure" should _always_ be executed when modifying data for...
-
RE: Using Parameters with Stored Procedures
... I love stuff like this. Maybe you should submit it to the script library! ...
Done
-
RE: Self-blocking
select
sum(BalAmt), -- sum does not use columns that have a null-status
sum(BalIntRate)
from DebtCurrBal c with(nolock)
join DebtBase d with(nolock)
on c.DebtBaseKey =...
-
RE: What happens after UPDATE statement?
check your execution plan !
I presume sqlserver in scanning
your full table and suffers a bunch of waits !"RowId is unique index" Is...
-
RE: Running 2000 Ent. Manager alongside 2005
I've reinstalled my test-dekstop with winxp sp2, added sql2000 client (no sp) and then sql2005 client.
Everithing works fine.
SQL2005 client is being instaled with these options :
ADDLOCAL=Client_Components,Connectivity,SQL_Tools90
,SQL_WarehouseDevWorkbench,SDK,SQLXML,Tools_Legacy
,SQL_Documentation,SQL_BooksOnline,SQL_Samples
-
RE: Linked server Out-of-Process
if this connection is to be used frequently , maybe enabling connection pooling is an option
control panel\data sources\connection pooling ....
This way your connection is kept alive (after the application...
-
RE: Linked server Out-of-Process
So apparently the problem is related to the speed of building a connection
or it might even be a connectionpooling problem. 
-
RE: Linked server Out-of-Process
Do you use a domain service account for sqlserver ?
0x80004005 is always an access problem
-
RE: Deduping Data in SQL Server 2005
nice example
Here is another :
WITH
cteEmployeeOrderedByMyRowNumber AS
(SELECT ROW_NUMBER()
-
RE: Job History entries clearing down by itself
check your sqlagent properties/ jobsystem and raise the jobhistory lines.
afaik there is no way of stating that each job should retain at least the last month or n-days of execution...
-
RE: [SQLSTATE 42000] (Error 3140)
What's DBCC CHECKDB stating ?
Also check out : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=197066
and http://www.portsense.com/ng/microsoft.public.sqlserver.server/2004/March/22/314579.cfm
-
RE: Windows scheduled tasks for OSQL
Just a wild shot :
What (type of) account is serving Scheduled Task ? Maybe it does not have the authority to access the batch or osql
-
RE: Query Performance
the best thing you can do is to use query analyser and use the "predict execution plan" (ctrl+L) or "show execution plan" (ctrl+k) option to check out what it's doing.
-
RE: Windows scheduled tasks for OSQL
- Any drivemapping involved ? use UNC in stead of drive-letters.
- capture your output
--> for the batch for osql use the -o parameter (check bol)
-
RE: Number of fields in SQL Server table
like always, it depends on the usage of your table.
400 columns/tb and normalized ?
I'm in no position to judge but this seems...
Viewing 15 posts - 6,361 through 6,375 (of 7,471 total)