Viewing 15 posts - 6,451 through 6,465 (of 7,425 total)
Very little to go on ... but here's my best guess so far:
IF EXISTS(SELECT 1 FROM sys.objects WHERE name = 'FACT_SalesAnalysis')
DROP TABLE FACT_SalesAnalysis
-- ...
March 21, 2013 at 5:25 pm
SELECT
DATEADD(HOUR, DATEDIFF(HOUR, 0, RunDateTime), 0) AS AvgHourlyDateTime,
--DATEADD(MILLISECOND, -3, DATEADD(HOUR, DATEDIFF(HOUR, 0, RunDateTime) + 1, 0)) AS AvgHourlyEndDateTime,
AVG([RowCount]) AS...
March 21, 2013 at 4:05 pm
It looks to me like you're checking all connections to the database. If there are many such connections for different users, that could be a drag on the trigger.
So,...
March 21, 2013 at 12:07 pm
Would need to also at least see the DDL ("CREATE TABLE"/"CREATE INDEX") for the tables, including all indexes.
March 21, 2013 at 11:50 am
You can use COALESCE(): for only 4 values, it's actually clearer to me personally (ymmv) than the other method.
SELECT
t.id,
COALESCE(t.field1, t.field2, t.field3, t.field4)...
March 21, 2013 at 11:27 am
Lynn Pettis (3/20/2013)
March 20, 2013 at 2:12 pm
FYI, a FILLFACTOR of 80 is wasting space in many tables and perhaps even still have too little freespace in others.
You need to determine the best FILLFACTOR for each table...
March 20, 2013 at 1:56 pm
Since the best plan will vary based on the selectivity of the specific @BatchID passed in, try it with the RECOMPILE option:
SELECT *
FROM <myDatabase>.<mySchema>.vw_BatchItems
WHERE BatchID = @BatchID
OPTION ( RECOMPILE );
March 19, 2013 at 1:28 pm
No, that's not how those counters work.
A single SELECT statement can, and very often will, generate multiple physical reads.
A single UPDATE or DELETE statement can, and very often will, generate...
March 19, 2013 at 1:19 pm
SELECT
'20130701' AS Date, Year,
6 AS JulyMaxhours,
SUM(6) AS Total_Hours,
KindOfDay, Month
FROM Auxiliary.Calendar
WHERE (KindOfDay =...
March 19, 2013 at 11:46 am
It's easy enough to generate the code for 00 to 99 based on the pattern for 00, so it's not really "manual" coding.
I figured on a (very broad) average of...
March 19, 2013 at 11:42 am
Not sure I fully understand, but maybe:
SELECT Date, Year, CASE DATEPART(mm, date) WHEN 07 THEN 6 END AS JulyMaxhours, KindOfDay, Month,
SUM(CASE WHEN DATEPART(mm, date) = 07 THEN 6 ELSE 0...
March 19, 2013 at 11:13 am
CREATE PROCEDURE [dbo].[GetExtractSiteExtractFileBatchPreviousSuccessInd]
@BatchStatusCd NVARCHAR(5)
,@ExtractSiteCd NVARCHAR(10)
,@ExtractAsOfDate DATETIME
AS
RETURN (
SELECT CASE
...
March 19, 2013 at 11:09 am
Maybe consider records to "match" if the SSN, first name and birth date all match. My reasoning: last name can change (marriage, etc.), and middle name may not be...
March 19, 2013 at 10:56 am
Or, depending on your specific needs, you could add your own logging/pseudotrace code to the proc itself, and trigger it with an optional parameter:
CREATE PROCEDURE dbo.proc_name
@...,
...
March 19, 2013 at 10:48 am
Viewing 15 posts - 6,451 through 6,465 (of 7,425 total)