Viewing 15 posts - 29,386 through 29,400 (of 49,552 total)
If you take a backup of database1 and restore it over database2, you are completely replacing database2 with database1. It's the equivalent of dropping (deleting) database2 completely, then restoring database1...
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
November 12, 2010 at 12:57 pm
bitbucket-25253 (11/12/2010)
Gail is the time you spend answering these e-mails billable to the client?If so ... rejoice, if not it should be.
Of course it is.
It's still time that I could...
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
November 12, 2010 at 12:52 pm
GSquared (11/12/2010)
about an hour later, you report back, "I found a really clever way to get that new request done ahead of deadline". 😀
Hell no, then they'll be expecting 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
November 12, 2010 at 12:49 pm
Tested and I can see it on my 2008 instance. You have permissions?
SELECT * from sys.configurations where configuration_id = 1577
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
November 12, 2010 at 10:27 am
Greg Edwards-268690 (11/12/2010)
Must be the Urgent! that rattled you.
Not just. I've been getting change requests at about 2 mails per day (multiple items per mail) this week. This 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
November 12, 2010 at 9:16 am
Do a wildcard search through sys.sql_modules
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
November 12, 2010 at 9:08 am
CirquedeSQLeil (11/12/2010)
GilaMonster (11/12/2010)
CirquedeSQLeil (11/11/2010)
I have a few articles that I am finishing up currently.Topics?
Physical Join Operators
Toss it over. If I need a break from genetic algorithms this weekend...
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
November 12, 2010 at 8:26 am
Jeff Moden (11/12/2010)
Paul White NZ (11/11/2010)
Did you also bust the myth that table variables are always estimated as containing one row?Statement level recompile?
Yup.
There's still no statistics, but the storage engine...
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
November 12, 2010 at 8:23 am
I swear this project is going to drive me to drink.
Email from BA/architect:
Urgent! Business confirms that it is possible to have more than one X per Y. Out design must...
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
November 12, 2010 at 8:09 am
djossoud (11/12/2010)
Victory! Thanks all! 🙂
What finally worked for 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
November 12, 2010 at 8:03 am
Stefan Krzywicki (11/12/2010)
Once everone who went to PASS is back (I think it is over now, yes?)
No, today's the postcon day (should be starting in about an hour).
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
November 12, 2010 at 7:52 am
Ray K (11/12/2010)
Congrats, Grant! Looking forward to congratulating you in person at SQL Saturday next week!
ps. (11/12/2010)
Congrates Grant for the MVP award.
Please note that this thread is well over a...
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
November 12, 2010 at 7:24 am
nigelrivett (11/12/2010)
Usually goes something likeselect s<space>
<delete the word>
s<space>
<delete the word>
s<space>
<delete the word>
s<right arrow>
Exactly. I can write queries faster without the built-in intellisense. With the aforementioned 3rd party version, I have...
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
November 12, 2010 at 7:15 am
srinadh.ramineni (11/12/2010)
Hi for the below questions i need good and efficient answers.
Homework? Interview? Exam?
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
November 12, 2010 at 6:40 am
You can't update them.
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
November 12, 2010 at 6:39 am
Viewing 15 posts - 29,386 through 29,400 (of 49,552 total)