Viewing 15 posts - 14,611 through 14,625 (of 49,552 total)
Can't be done, the system database model is used as a model for new databases.
You can put small objects in model (small, not huge, model is the template for TempDB...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2013 at 7:12 am
Creating any database uses model as the template.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2013 at 3:01 am
Alexander Suprun (1/25/2013)
Joechelad (1/25/2013)
The best solution is to assign the OS 20%
Very-very bad advice. 20% of 128GB is 25Gb, are you sure you want to allocate so much memory for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 26, 2013 at 2:49 am
Steve Jones - SSC Editor (1/25/2013)
Are the posted posts about the posted questions and posted answers getting posted worse-ly than previous posters posted in the posted past?
42.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 11:41 am
Table definitions. Index definitions.
Edit: and the actual plan please, not estimated.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 11:11 am
John Carter (it's nothing like the book series, other than in general plot), the Avengers. Didn't watch too many movies last year though.
I didn't enjoy the Hobbit. Was stretched too...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 10:40 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 10:18 am
Since apparently I don't have an idea about partitioning, can someone help this poor person? 😉
http://www.sqlservercentral.com/Forums/Topic1411242-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 10:15 am
No, that's not very efficient (any conversions to varchar in a date function should be suspect).
DECLARE @CurrentDate DATETIME
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
SET @CurrentDate = GETDATE()
SELECT @StartDate = DATEADD(hh,18,DATEADD(dd,4,DATEADD(wk, DATEDIFF(wk,0,@CurrentDate)-1, 0)))
SELECT...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 10:12 am
Not just indexes. A change in the data volume in the table could easily have the same effect. The query is non-deterministic.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 10:01 am
Keep foreign keys (unless you like dealing with garbage data), partitioning is for management of data, not performance. Query and index hints are the very last resort for tuning queries...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 9:15 am
Ed Wagner (1/25/2013)
As a word of caution, I believe you can do online index rebuild only with the Enterprise Edition of SQL Server.
and only in SQL 2005 above,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 9:10 am
Express can't use more than 1 GB of memory, so unless you want to set max memory below that for some reason, no.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 7:41 am
Please run the following and post the full and complete, unedited output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 7:38 am
Gowthu (1/25/2013)
from
(select n1.Acct,n1.max_insert_no
from
(select Acct,MAX(last_insert)max_insert_no
from
(select Acct,ROW_NUMBER() over (partition by Acct order by Acct)last_insert from Table_1)n
group by Acct)n1
)n2
join
(select Acct Acct1,Amt,ROW_NUMBER() over (partition by Acct order...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 25, 2013 at 7:34 am
Viewing 15 posts - 14,611 through 14,625 (of 49,552 total)