Viewing 15 posts - 12,466 through 12,480 (of 49,557 total)
sqlpanther (7/3/2013)
my analysys says out tempdb is not flushing the commited transaction
Won't be the cause.
If TempDB is growing to 60GB, then you have stuff (temp tables, table variables, internal query...
July 5, 2013 at 6:17 am
Not possible. You cannot in any way configure any of the attributes of the default trace.
July 5, 2013 at 6:15 am
sandippani (5/11/2013)
Nice attempt. Here in this article you should explain why SQL server does like this. I'm referring to the Index Statistitics.
It's not due to statistics. It's due to the...
July 5, 2013 at 1:37 am
Try using extended events.
July 5, 2013 at 1:20 am
Identity is not and never has been guaranteed to be without gaps. Hence the presence of such gaps it to be expected.
If the service is restarting, you probably want to...
July 5, 2013 at 1:13 am
There are multiple different ways to do this.
Rank or row number
Max in a subquery and join to it
Top 1 in a cross apply
All will likely be way faster than a...
July 5, 2013 at 1:12 am
Query 2.
SELECT * FROM (
SELECT
o.OrderDate,
o.AccountNumber,
o.TotalDue,
o.SalesPersonID,
p.FirstName,
p.LastName,
ROW_NUMBER() OVER (PARTITION BY YEAR(o.OrderDate), MONTH(o.OrderDate) ORDER BY o.TotalDue desc) MonthPosition
FROM Sales.SalesOrderHeader AS o
INNER JOIN Person.Person AS p
ON o.SalesPersonID = p.BusinessEntityID
) sub
WHERE MonthPosition = 1
ORDER...
July 4, 2013 at 4:21 pm
Query 1.
SELECT * FROM (
SELECT o.SalesOrderID,
o.OrderDate,
o.AccountNumber,
o.TotalDue,
o.SalesPersonID,
p.FirstName,
p.LastName,
ROW_NUMBER() OVER (PARTITION BY o.SalesPersonID ORDER BY o.TotalDue desc) SalesPersonPosition
FROM Sales.SalesOrderHeader AS o
INNER JOIN Person.Person AS p
ON o.SalesPersonID = p.BusinessEntityID
) sub
WHERE SalesPersonPosition = 1
ORDER BY...
July 4, 2013 at 4:15 pm
Then someone has likely implemeted a DDL trigger without your permission. Check under server triggers in management studio.
Reason is, create database does not run any select statements but your error...
July 4, 2013 at 9:23 am
For max worker threads, query sys.configurations. If it's 0, then see this article for the calculation of effective worker threads
http://msdn.microsoft.com/en-us/library/ms189631.aspx
Current you can get by querying sys.dm_os_workers
July 4, 2013 at 8:50 am
Speak to your DBA. If there is one, he'd have had to implement it.
July 4, 2013 at 8:42 am
Do you have a DDL trigger implemented that fires for create database statements?
July 4, 2013 at 8:12 am
Repeating the exact same thing is not explaining.
What do you consider an I/O error? What do you want the query to show?
July 4, 2013 at 8:10 am
Viewing 15 posts - 12,466 through 12,480 (of 49,557 total)