Viewing 15 posts - 19,081 through 19,095 (of 49,552 total)
Spam. Reported. No replies please.
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
April 16, 2012 at 3:18 am
Spam. Reported. No replies please.
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
April 16, 2012 at 3:18 am
itskanchanhere (4/16/2012)
Option 1 or option 2??
Both are true.
The query reads uncommitted data and any other session is able to update, insert or delete rows that the select query is busy...
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
April 16, 2012 at 3:11 am
Yes.
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
April 16, 2012 at 3:10 am
A restart is not required. The additional files will be created when you run the alter database and SQL will start using them. If you want to restart, you can.
If...
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
April 16, 2012 at 3:08 am
sqlfriends (4/15/2012)
Yes, this server we don't have max memory set, this is a server that has 7 GB memory.
Yup, as I thought. That's your problem right there.
CheckDB does a huge...
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
April 16, 2012 at 3:06 am
You absolutely do need to do integrity checks of read only databases. A misbehaving IO subsystem is not polite enough to check the read only property before it mangles 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
April 15, 2012 at 6:00 pm
The Dixie Flatline (4/15/2012)
I shut off the tap that is my mouth.
That's not what I was saying...
Grant's avatar appears to be a glass that's overflowing, so my answer 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
April 15, 2012 at 3:18 pm
The Dixie Flatline (4/15/2012)
Hushing up now.
???
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
April 15, 2012 at 2:41 pm
Way out of my neck of the woods, I'm afraid. I know some people in the USA who are very good at this sort of thing, but none are cheap....
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
April 15, 2012 at 2:20 pm
GilaMonster (4/15/2012)
And the link I posted shows you how to get the first day of the month if any date is given.
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
April 15, 2012 at 2:17 pm
Sourav-657741 (4/15/2012)
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
April 15, 2012 at 2:04 pm
hbtkp (4/15/2012)
i havent missed anything.
Yes, you have. You've missed the fact that the @row needs to be set to the FIRST DAY OF THE MONTH.
I've said that three times now....
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
April 15, 2012 at 2:00 pm
Is this PHP with a MySQL backend?
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
April 15, 2012 at 1:55 pm
Sourav-657741 (4/15/2012)
Hi,We have a lot of procedures which internally uses the temp tables. But the procedures are not ended with dropping the temp tables.
Can this create deadlocks in tempdb?
No. 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
April 15, 2012 at 1:54 pm
Viewing 15 posts - 19,081 through 19,095 (of 49,552 total)