Forum Replies Created
Viewing 15 posts - 5,866 through 5,880 (of 9,722 total)
-
RE: SQL Server has encountered 16 occurrence(s) of cachestore flush
Gail already told you what was happening. Restores will clear the plan cache. The fact that this is a secondary log shipping server means that every time a log is...
-
RE: Error 1105 when there are no space issues
A couple of things. You can get this error if the drive that TempDB is on happens to be full or if its Primary filegroup is at its max growth...
-
RE: Database ID 6, Page (1:1324) is marked RestorePending
Have you verified that there are no page restores currently happening on the database?
What version of SQL 2k5 are you running? (SP3 or above?) Because if you're running a service...
-
RE: Convert integer
I'm confused as well. I'm assuming "they" is your client. But the fact that they don't like big numbers and you are generating a random 50 character number that you...
-
RE: Error :64(The specified network name is no longer available.)
Bhuvnesh (6/10/2011)
thanks it has been resolved it happened due to some network issues.That's usually what that error means. Glad you got it resolved.
-
RE: Run SQLJob via stored proc as a different user
It occurs to me to wonder if the SQL users even have permissions to run your proc. If they don't, then EXECUTE AS won't do you any good.
If this is...
-
RE: Are the posted questions getting worse?
Salary.com posted an interesting click-thru article about 14 job hunting mistakes. Though y'all would be interested.
Upper left, under the banners:
http://www.salary.com/Articles/ArticleDetail.asp?part=par4104
EDIT:
Found another one. This one about bad habits.
-
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (6/9/2011)
Brandie Tarvin (6/9/2011)
Hey, Steve (and other Prius owners), I just heard about this and wanted to pass it along:Toyota says a problem with electric power...
-
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (6/9/2011)
Brandie Tarvin (6/9/2011)
Just a reminder for anyone in or near Dallas this weekend. I'll be attending A-kon 22 to promote and sign anthology copies of... -
RE: Databases left in a recovering status when using high performance database mirroring
No, but only because I don't use DB Mirroring at the moment. But it sounds like a resource issue since you're mirroring 6 dbs on that one instance.
Have you run...
-
RE: Memory Allocation on Virtual Server
So it's just that it will cause SQL Server to not use all the physical memory, not that it will cause the Zombiepacolypse or something equally horrendous, right?
-
RE: SQL Server service won't start due to the mssqlsystemresource database files not accessible
Silly question that may not have anything to do with anything... Are you sure that the drive / folder in question has enough disk space for that database to even...
-
RE: Memory
Then consider your issue might be that you have too much database and not enough memory. Altering the memory allocation is unlikely to fix performance issues if the server is...
-
RE: Memory
sqlfriends (6/9/2011)
It's impossible for us now to get another sandbox for us to play with, no budget for that, the server hosts 4 vendor applciations related with network monitoring, ITSM,... -
RE: Are the posted questions getting worse?
jcrawf02 (6/9/2011)
Jim Murphy (6/9/2011)
GilaMonster (6/9/2011)
I post too much.Congrats Gail! That's awesome.
The best part is that your posts are not useless point-getting restatements. Grrrr, I hate those. You post...
Viewing 15 posts - 5,866 through 5,880 (of 9,722 total)