Viewing 15 posts - 9,001 through 9,015 (of 49,552 total)
Just change it. Database settings aren't replicated and recovery model has no effect at all on replication.
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
May 20, 2014 at 6:16 am
No idea. Look up UidcreateSequential in your development language's documentation and see what it is and how it behaves.
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
May 20, 2014 at 5:30 am
If you're inserting NEWID() explicitly, it doesn't matter in the slightest whether there's a default defined on the column or what the default is, the values inserted are the same....
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
May 20, 2014 at 4:36 am
Oracle_91 (5/20/2014)
So as a whole, sql server memory and can be paged out by OS whenever there is memory pressure.
When the OS is under memory pressure.
There are two different scenarios....
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
May 20, 2014 at 3:31 am
I assume you mean Count...
select COUNT(*) as [type], [group]
from tblname
where group in ('a','b')
Group by [group]
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
May 20, 2014 at 3:30 am
Wait.
Recovering means that SQL is running restart-recovery on the database. When it finishes the DB will come online.
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
May 20, 2014 at 3:14 am
What error is the backup failing with?
Why do you think you need to rebuild master?
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
May 20, 2014 at 3:13 am
Oracle_91 (5/19/2014)
The reason why I am confirming is, as you said, sql server data will never goes into windows page file and sql never uses page file.
No. I said:
The page...
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
May 20, 2014 at 2:20 am
No, the fragmentation will be the same, both are having NEWID() specified as the value so the default is being overridden.
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
May 20, 2014 at 2:16 am
Then when 2008 was installed, a new instance wasn't created. Possibly just the client tools were installed. You'll need to reinstall and install a new SQL instance.
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
May 19, 2014 at 7:32 am
Check the SQL configuration manager, it'll show you all the services installed.
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
May 19, 2014 at 7:27 am
If you have a SQL 2008 R2 instance, connect to that and you'll be able to restore a DB and set it's compat mode to 100.
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
May 19, 2014 at 7:19 am
You're connected to the SQL 2005 instance. See if there's a 2008 instance installed (check services), if there is, connect to that. If not, install a SQL 2008 instance.
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
May 19, 2014 at 7:17 am
If there is a SQL 2008 database engine, connect to that and you can set a database's compat level to 100. If there's only a SQL 2005 database engine, then...
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
May 19, 2014 at 7:15 am
Grant Fritchey (5/19/2014)
jcrawf02 (5/19/2014)
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
May 19, 2014 at 7:12 am
Viewing 15 posts - 9,001 through 9,015 (of 49,552 total)