Viewing 15 posts - 6,841 through 6,855 (of 49,552 total)
jacksonandrew321 (1/8/2015)
Yes, I did and path is valid.
Except that it's missing a file name in one place and missing the entire path in the other.
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 8, 2015 at 2:27 am
Is the windows user in any other domain group which has login to SQL?
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 8, 2015 at 2:05 am
That's data formatting, Crystal Reports is completely the correct place to do that.
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 8, 2015 at 1:55 am
jacksonandrew321 (1/8/2015)
Msg 15240, Level 16, State 1, Line 26
Cannot write into file 'SQLPrivateKeyFile'. Verify that you have write permissions, that the file path...
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 8, 2015 at 1:54 am
rummings (1/7/2015)
I do not understand the "correctly scheduled" part.... how do you know the correct schedule?
The schedule you're using. So if you have them scheduled every 2 hours,...
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 8, 2015 at 1:35 am
Stefan Krzywicki (1/7/2015)
SQLRNNR (1/7/2015)
Stefan Krzywicki (1/7/2015)
Steve Jones - SSC Editor (1/7/2015)
Ahhh, the cloud... http://www.computerworld.com/article/2865802/verizon-warns-enterprise-cloud-users-of-48-hour-shutdown.html
Wow, that's a complete disaster. I wouldn't just be "downloading data to make sure I had access...
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 8, 2015 at 1:28 am
How did you create them, how did you install them, where are you looking for them and what problems are you having with taking a backup?
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 8, 2015 at 1:24 am
New Born DBA (1/7/2015)
GilaMonster (1/7/2015)
New Born DBA (1/7/2015)
Tuesday, it got executed around 6400 times and cumulative wait time was about 18:00 minutes (LCK_M_X).
So on average each update waited 15ms 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 7, 2015 at 9:02 am
You should always set max server memory.
SQL does use memory outside of the buffer pool (which is what max server memory sets). Thread stacks, backup buffers, linked server drivers, CLR....
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 7, 2015 at 8:59 am
New Born DBA (1/7/2015)
Tuesday, it got executed around 6400 times and cumulative wait time was about 18:00 minutes (LCK_M_X).
So on average each update waited 15ms for a lock. Is 15ms...
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 7, 2015 at 8:44 am
rummings (1/7/2015)
I renamed log file.... reattached.
Russian roulette with a database.... Seriously don't do that.
Read through the article I posted please, it describes how to find why the log is not...
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 7, 2015 at 8:41 am
DBA_Learner (1/7/2015)
The problem with my organization is lack of knowledge about RTO.
Then you need to educate them, they're not going to gain knowledge otherwise. Someone who know about the...
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 7, 2015 at 7:37 am
Take a read through this, post back if you need help with any specifics
http://www.sqlservercentral.com/articles/Transaction+Logs/72488/
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 7, 2015 at 7:19 am
No. Single witness.
If you lose the witness, all you lose is automatic failover.
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 7, 2015 at 7:05 am
Grant Fritchey (1/7/2015)
Further, your databases may have to be distributed across multiple servers through sharding in order to ensure additional redundancy.
In multiple data centers, with redundant network connections (not...
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 7, 2015 at 7:02 am
Viewing 15 posts - 6,841 through 6,855 (of 49,552 total)