Viewing 15 posts - 33,436 through 33,450 (of 59,102 total)
Craig Farrell (6/28/2011)
Here's where that concept gets caught. Yes, YOU as a DBA may own your server's code. I know many, including myself depending on the environment, who don't.
So......
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2011 at 7:52 pm
Readability? Absolutely. You'll get no argument from me there.
Performance? I gotta go with a "maybe" (or at least IMHO :-P). On another link, you said it...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2011 at 7:43 pm
Gianluca Sartori (6/28/2011)
Yeah! 3000 points for me!It's a small step for most of you, it's a great step for me.
Way to go, Gianluca! 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2011 at 6:35 pm
Koen Verbeeck (6/28/2011)
Chad Crawford (6/28/2011)
Wahoo! My users group just scheduled me to speak in August. Let the stress begin.... 😀
Congratulations.
I did my very first technical session last...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2011 at 6:20 pm
ganci.mark (6/28/2011)
Late yesterday the developer reported this occuring again so I investigated.
By this time I was convinced it had to be something they were doing.
I inserted a test record and...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2011 at 6:15 pm
Absolutely outstanding, Matt! I didn't even think to ask you if you had matched datatypes because I included it all in the code example. VERY happy you sussed...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 28, 2011 at 5:51 pm
maheshkrishnas (6/27/2011)
SELECT TOP 1000 [C_ID]
,[C_NM]
...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 11:14 pm
Duplicate post. No replies here, please. Please see:
http://www.sqlservercentral.com/Forums/Topic1132030-392-1.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 11:14 pm
ganci.mark (6/24/2011)
After inserting rows into a table and receiving no errors and xx row(s) inserted messages,
Selecting from the table yielded no rows. Select count(*) resulted...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 10:47 pm
opc.three (6/27/2011)
stormsentinelcammy (6/27/2011)
Please post how to select the tables belonging to a certain schema 🙂
Please start a new thread 🙂 The OP wanted to know if it was possible, not...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 10:34 pm
opc.three (6/27/2011)
SELECT jc.OrderNum,
dbo.GROUP_CONCAT(DISTINCT OrdCountry) AS OrdCountries
FROM ...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 10:24 pm
aatishpatel (6/27/2011)
I would change the database recovery to simple or bulk logged.
[font="Arial Black"]WHY???[/font]
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 10:12 pm
Based on the little bit of info you've given us, this sounds like either an intermittent network or file system error.
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 9:46 pm
Depending on what you're looking for, you can right-click a server is SSMS and then select "Reports". There you will find a large number of reports and some of...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 9:43 pm
Gosh... good questions, Craig.
If we can, in fact, put aside the idea that Developers frequently have no readability on a production database or server, here's my "It Depends" answer. 😉
The...
--Jeff Moden
Change is inevitable... Change for the better is not.
June 27, 2011 at 9:23 pm
Viewing 15 posts - 33,436 through 33,450 (of 59,102 total)