Viewing 15 posts - 26,761 through 26,775 (of 49,552 total)
Process of elimination. It said 'pick 3', so I looked for the two that can't be single-page restored.
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 12, 2011 at 9:25 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1092126-1550-1.aspx
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 12, 2011 at 8:39 am
Please post new questions in a new thread. Thank you.
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 12, 2011 at 8:36 am
SanDroid (4/12/2011)
GilaMonster (4/12/2011)
Piquet (4/12/2011)
- Inserts into Table Variables...
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 12, 2011 at 8:35 am
sathishmangunuri (4/12/2011)
I found principal_id column in both sys.server_principals table and sys.tables,but sys.tables table has null values....where as sys.server_principals table holds unique value for one user.....
The princpial_id in sys.tables is 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 12, 2011 at 5:41 am
Yup. Very bad practice.
You need to create an account with minimal permissions, just what the web site needs to run. There is no way that it needs sysadmin-level permissions 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
April 12, 2011 at 4:37 am
http://msdn.microsoft.com/en-us/library/ms190692.aspx
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 12, 2011 at 4:24 am
Piquet (4/12/2011)
- Inserts into Table Variables are 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
April 12, 2011 at 4:17 am
Flesh the abstract out. You need more detail on what's in, what we'll learn to submit to Pass.
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 11, 2011 at 11:47 pm
Trey Staker (4/11/2011)
Jeff Moden (4/11/2011)
GilaMonster (4/11/2011)
After 30 minutes of arguing about set theory, equivalence of statements, testing requirements and development methodology I gave up and discarded the changes.
That's why I...
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 11, 2011 at 11:38 pm
keepintouch2b (4/11/2011)
For SQL Server 2008 or Denali, I...
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 11, 2011 at 11:34 pm
Darkness (as in, 'the city is 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
April 11, 2011 at 3:31 pm
What are you trying to do here?
As mentioned, tables don't have a built-in row number, so please explain a bit clearer what it is that you are trying to do.
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 11, 2011 at 2:35 pm
Jack Corbett (4/11/2011)
GilaMonster (4/11/2011)
GSquared (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.What/who is it?
And what was wrong with the lizard?
Can't recall, I deleted 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 11, 2011 at 2:31 pm
Craig Farrell (4/11/2011)
GilaMonster (4/11/2011)
Ok, had enough complaints about the lizard. Let's see if this is better.
:blink: Whaaa?
Good to see the dead hopeless romantic virgin again. I never could decide...
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 11, 2011 at 1:30 pm
Viewing 15 posts - 26,761 through 26,775 (of 49,552 total)