Viewing 15 posts - 13,831 through 13,845 (of 49,552 total)
foscsamuels (3/18/2013)
After this discussion, I set max server memory...
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
March 18, 2013 at 4:40 pm
UncleBoris (3/18/2013)
So if a DB server totally dies and it is not recommended that the Master is restored on another machine then what would be the normal...
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
March 18, 2013 at 4:21 pm
SQL doesn't page out it's own memory. The OS may page SQL out if its under memory pressure. Older versions of the OS (Server 2003) were more agressive about this,...
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
March 18, 2013 at 10:47 am
clintonG (3/18/2013)
However doesn't Group Policy Editor remain accessible to any Windows 7 Administrator anyway?
Err, huh?
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
March 18, 2013 at 9:32 am
No conflict.
Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 2010 10:38:40 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit)
SQL Server 2005 SP 4 X64 Standard...
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
March 18, 2013 at 9:28 am
Murat Korkmaz (3/18/2013)
Can you please tell me more about the little thing where I am interested in?
What little thing that you're interested in?
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
March 18, 2013 at 9:25 am
You're running into this: http://www.benjaminnevarez.com/2011/05/optimizer-statistics-on-linked-servers/
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
March 18, 2013 at 6:54 am
The size of the database has little to do with mirroring. The volume of transactions will affect what kind of connection you need between the servers.
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
March 18, 2013 at 6:14 am
There's something in that column that won't convert to date.
Try this, see what you get:
SELECT CONVERT(CHAR(8), EZACDT)
FROM SYM_SPT_SNI_01.dbo.DBA_MVX_CINACC00
WHERE EZCONO = 2
AND EZDIVI = '001'
AND ISDATE(CONVERT(CHAR(8), EZACDT)) = 0;
Not a...
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
March 18, 2013 at 3:33 am
Don't move master databases from one server to another, asking for trouble.
As for how you fix the missing model problem:
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
March 18, 2013 at 3:30 am
How is your guideline of leaving 2GB for the OS and monitoring accordingly different from Jonathan's guideline of leaving an amount of memory dependant on the total server memory 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
March 18, 2013 at 3:06 am
Active /active (which really is a tern that shouldn't be used any longer) is just 2 active/passive SQL server failover instances on the same cluster.
More correctly called 'multi-instance cluster', 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
March 18, 2013 at 2:29 am
Please note: 3 year old thread.
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
March 18, 2013 at 2:16 am
Dynamic SQL is the only way you can do that.
I strongly recommend you do not go this route. Procedures should have a well-defined function, not do whatever based on a...
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
March 17, 2013 at 3:13 pm
clintonG (3/17/2013)
The SQLExpress database will be intsalled on a share of a Windows7 machine
Errrr....
SQL is not Access. It's not a file-based database that sits on a share. It's a...
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
March 17, 2013 at 3:06 pm
Viewing 15 posts - 13,831 through 13,845 (of 49,552 total)