Sum - Join
Thu, 18 Mar 2010 22:46:01 -0700
Hi.
When I use Sum and Count function in Left Outer join the Count() returns
the correct value while sum() returns incorrect value.
Regards,
Muhammad Bilal ...
|
xp_smtp_sendmail
Thu, 18 Mar 2010 22:20:03 -0700
Hi,
MSSQL2000
I still have my old application running on SQL2000, which uses
xp_smtp_sendmail , a simple email sending Extendend store procedure which I
downloaded from the web back in 2004. I remember it has some dll to register
and few more steps. As I have to re-install the SQL, so lost these compone ...
|
Create new sequence for batch of inserted rows
Thu, 18 Mar 2010 22:40:41 -0400
This is in SQL Server 2008. Suppose I'm running an annual auction for an
organization. My database has a Member table which has the
organization's members from the last however many years, with a status
that equals 1 for members who are currently active. There is also a
Bidder table that, for each year, incl ...
|
ddl and transactions
Thu, 18 Mar 2010 20:40:17 -0400
i guess i never thought about this before but if i am changing a proc while a transaction is running the new proc is
live the moment the alter is complete. I would have thought that procs are versioned like data is during a transaction.
for example
user1 starts tran
user1 exec proc1
user2 alters proc1
us ...
|
Profiler doesn't seem to work on filters
Thu, 18 Mar 2010 17:23:49 -0700
The loginName filter seems to work fine, but not the TextData filter.
When I select the TextDataColumn and put 'GetPermissions%' in the LIKE
fields, it still gives me everything.
I am trying to run my applications to find all the places this is called so
I set up the filter to only show me events where Get ...
|
Unique unless null?
Thu, 18 Mar 2010 19:37:24 -0400
Is there a way to set up a constraint, or something with the effect of a
constraint, to prevent two rows in a table from having the same non-null
value in a particular column while allowing multiple rows to have NULL
in that row? Consider a table, some of whose data is imported from an
external source, and t ...
|
Issue installing SQL Server 2005 with SSRS 64-bit on Windows Server
2008 SR2
Thu, 18 Mar 2010 16:27:22 -0700 (PDT)
When installing SQL Server 2005 64-bit on Windows Server 2008 SR2, it
seems only allow the 32-bit version of SQL Server Reporting Services
to be installed. There doesn't seem to be an option to install the 64-
bit version. ASP.NET is installed as 64-bit, but a warning comes up
saying that ASP.NET 32-bit needs ...
|
|
|
Running Engine Tuner
Thu, 18 Mar 2010 12:09:03 -0700
I am getting the following errors running the Engine Tuner on my trace.
Could not find Stored Procedure dbo.TempGetStateItemExclusive3
Could not find Stored Procedure dbo.TempUpdateStateItemLong
Could not find Stored Procedure dbo.TempReleaseStateItemExclusive
Error encountered while generating reports. Write ...
|
transaction without a request
Thu, 18 Mar 2010 11:43:01 -0400
This doesn't return anything
SELECT *
FROM sys.dm_exec_requests
WHERE Session_ID = 187
--this does
SELECT *
FROM sys.dm_tran_session_transactions
WHERE Session_ID = 187
--as does this
SELECT *
FROM sys.dm_exec_sessions
WHERE Session_ID = 187
how can a session be in a transaction without having an ...
|
SQL 2005 CLR
Thu, 18 Mar 2010 07:13:01 -0700
Not sure if this is the correct place but here goes.
I have a CLR which basically reads windows performance counters(Logical
Disk). I run the created SP from one server and pass in the name of another
server. This works fine for all the servers on the same domain. If I try to
run against a server in a differe ...
|
