Viewing 15 posts - 8,821 through 8,835 (of 49,552 total)
Jeff Moden (5/30/2014)
To fix the negative space available thing, try running the following in the database you're having problems with...DBCC UPDATEUSAGE (0);
Because there are bugs in SQL 2000's free space...
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
June 6, 2014 at 12:43 am
The backup buffers are not part of the 20GB allocated to the buffer pool. They are outside the buffer pool.
Trying to find out how the 20GB of buffer pool is...
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
June 5, 2014 at 12:53 pm
Backup buffers are outside of the buffer pool, so not part of the 20GB that max server memory sets
Is this 32 bit?
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
June 5, 2014 at 7:32 am
Why do you need to snapshot the entire database every 15 min? If it's to keep two sites in sync, wouldn't transactional replication be a better fit?
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
June 5, 2014 at 7:10 am
Koen Verbeeck (6/5/2014)
GilaMonster (6/5/2014)
thomashohner (6/5/2014)
What is the preference on column aliases ?AS. Equals sign is for comparing values or assigning values. 😀
Yes, you assign the result of the expression to...
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
June 5, 2014 at 6:53 am
It takes schema locks, if I recall, so nolock will still be blocked (and even if it wasn't, are you as happy about duplicate rows?)
Init from backup if the snapshot...
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
June 5, 2014 at 6:49 am
thomashohner (6/5/2014)
What is the preference on column aliases ?
AS. Equals sign is for comparing values or assigning values. 😀
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
June 5, 2014 at 6:46 am
Koen Verbeeck (6/5/2014)
I think this thread sums up the general feeling towards code formatting displayed in this thread.http://www.sqlservercentral.com/Forums/Topic1577630-391-1.aspx
There is soap behind the counter to wash your eyes with...
Gah.... :crying:
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
June 5, 2014 at 6:36 am
devorlask (6/5/2014)
Thanks, was more so looking to try and break down the tran log after a weeks loading and querying but it seems that it isn't that straight forward.
No, it...
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
June 5, 2014 at 3:54 am
rajesh.mekala (6/4/2014)
please tel me yaar how to reslove this issue permently please give explain brefily
Call Microsoft Support, open a case.
Alternatively, if you want free help maybe give us...
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
June 5, 2014 at 3:51 am
free_mascot (6/4/2014)
what is .mpmp format?
It's a mini-dump file. Written when SQL throws access violations or similar severe errors. The goal should be identifying why SQL is throwing access violations and...
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
June 4, 2014 at 7:57 am
Timeout is a client-side concept. SQL has no idea what a timeout is, it will run queries for however long they take. It's client apps that get impatient and send...
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
June 4, 2014 at 7:31 am
Why do you think that the replication log reader, a process which runs all the time to implement replication, is a problem?
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
June 4, 2014 at 6:53 am
Server-side trace or extended events to trace what's running.
While it is possible to query the transaction log, all you will be able to see is the details of what operations...
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
June 4, 2014 at 6:52 am
jasona.work (6/3/2014)
You know, I'd not really thought about this until now, but...How do people find all these "undocumented" options for various SQL commands?
Management Studio, definitions of system procedures/functions. Debugger with...
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
June 3, 2014 at 2:59 pm
Viewing 15 posts - 8,821 through 8,835 (of 49,552 total)