Viewing 15 posts - 31 through 45 (of 521 total)
Check the [Total Executions] and other statistics for each report:
SELECT Catalog.Name AS Report_Name,
AVG(ExecutionLog.TimeDataRetrieval) AS AVG_QueryTime,
...
November 13, 2009 at 7:40 am
This gives you a detail list:
SELECT F.[user_id], F.First_Purchase_Date
FROM (
SELECT [user_id],
MIN(dbo.orders.created_date) AS First_Purchase_Date
FROM dbo.orders
WHERE base_price > 0
GROUP BY [user_id]) F
WHERE F.First_Purchase_Date >= DATEADD(DAYOFYEAR, - 1, GETDATE())
November 13, 2009 at 6:31 am
By default SQL Server manages the number of concurrent connection automatically and the hard limit is 32767.
November 11, 2009 at 7:37 am
take a look at sys.dm_os_tasks. If a request (session_id,request_id) runs in parallel, it has more than one entries.
SELECT session_id,request_id,count(*) as Parallel
FROM sys.dm_os_tasks
WHERE session_id IS NOT NULL AND request_id IS NOT...
November 4, 2009 at 7:55 am
Try this:
SELECT r.*,t.text FROM sys.dm_exec_requests r cross apply sys.dm_exec_sql_text(r.sql_handle) t
WHERE r.status IN (N'Suspended',N'Running',N'Runnable',N'Pending')
The text column is the code of the procedure/batch that is currently running in SQL Server
If all your...
November 4, 2009 at 7:35 am
Double chekced, The bug I mentioned is fixed in SQL SERVER 2005 SP3. You may want to apply SP3 and try again
October 30, 2009 at 1:35 pm
You need to have Status column in your task table, e.g. TaskID int not null, Status bit not null
You can have code something like:
DECLARE @TaskID int
BEGIN TRAN
SELECT @TaskID = MIN(TaskID)...
October 30, 2009 at 11:51 am
I have 32bit named instance 2K8 and alias works fine with named pipe protocal.
When you define the alias on the client machine, double check the pipe name is the same...
October 30, 2009 at 7:20 am
CREATE TRIGGER YourTrigger ON YourTable
FOR INSERT
NOT FOR REPLICATION
AS
.....
October 30, 2009 at 6:57 am
What service pack are you running? I remember SQL Server 2k5 had a bug. If you have SP1 or earlier and use blob data type (e.g. text), the database cannot...
October 30, 2009 at 6:33 am
October 29, 2009 at 6:41 am
first edit your execute statement, e.g.:
exec yourSP @Parm1='V1',@Parm2='v2'
then click the green arrow button or debug->start debugging menu, the press F11 to step into the SP.
October 27, 2009 at 8:44 am
if you have IA64 machine, the answer is NO
if you have 32bit or x64, the answer is Yes.
You need to install SQL 2008 database engine and ssrs, sql 2000 will...
October 27, 2009 at 8:17 am
Instances per computer
32bit:
50 instances on a stand-alone server for all SQL Server editions except for Workgroup. Workgroup supports a maximum of 16 instances per computer.
SQL Server supports 25...
October 27, 2009 at 6:59 am
PIVOT is definitely one unfinished or not properly finished feature. You need to hard code the values for the pivoted column. Otherwise you still to use dynamic SQL. E.g.:
USE...
October 19, 2009 at 6:48 am
Viewing 15 posts - 31 through 45 (of 521 total)