Viewing 15 posts - 7,876 through 7,890 (of 19,564 total)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and...
November 14, 2011 at 8:09 am
Ninja's_RGR'us (11/14/2011)
crookj (11/14/2011)
Ninja's_RGR'us (11/11/2011)
SQLRNNR (11/11/2011)
Ninja's_RGR'us (11/11/2011)
Confusing with Britney?Well they did kiss. I could see how that mistake could be made.
Good point! 😀
Adds a whole new meaning to lip sync...
Ya...
November 14, 2011 at 8:08 am
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find...
November 14, 2011 at 8:06 am
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find that script....
November 14, 2011 at 7:20 am
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!
Thanks - you were quick on that. I just got the email this morning.
November 14, 2011 at 7:02 am
So on this other system which did you do?
dbcc dbreindex (deprecated way to rebuild indexes)
alter index rebuild
alter index reorganize
and which did you attempt on the prod?
Just curious.
November 13, 2011 at 8:59 pm
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find that script. But...
November 13, 2011 at 8:53 pm
Alan Naylor (11/13/2011)
The primary keys are fragmented too and can't drop them without dropping constraints and that's not a good idea to do on live production.
You don't need to drop...
November 13, 2011 at 8:46 pm
What is preventing you from doing this maintenance on the actual prod server?
November 13, 2011 at 8:24 pm
michael.french 172 (11/9/2011)
Apparently I am a Pediatric Dentist. My kids will be thrilled to find that out.
Oh the money I could save if I were a Pediatric Dentist.:-D:-D:-D
November 13, 2011 at 5:40 pm
I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a proc were prefixed with tbl_...
November 13, 2011 at 5:13 pm
I agree with Gail. I really hate the vw_ or tbl_ or variations of such prefixes. I have inherited databases like that and the re-factoring problem is coming...
November 13, 2011 at 5:10 pm
It was good chatting Steve. Also good to see some of the other people like Tom, Robert, Andy, Mike and Mike, Brian and Matt.
It was also fun to run...
November 13, 2011 at 3:57 pm
btio_3000 (11/12/2011)
Dev (11/12/2011)
If you have start with Node 8 as Child, it has 2 parents (6&7)
6 has 2 parents -> 2...
November 13, 2011 at 2:20 pm
Viewing 15 posts - 7,876 through 7,890 (of 19,564 total)