Viewing 15 posts - 19,981 through 19,995 (of 59,072 total)
Might have to add the 3 different WHERE clauses to that... they are all different.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2015 at 8:34 am
Then you might want to consider the methods in the attached presentation. It's definitely worth going through the presentation in the "present" mode because it's somewhat animated to explain...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2015 at 7:59 am
To add to what Phil stated, text qualifiers are usually conditional. That is, the system only considers them when they are present. They aren't treated as if they...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 4, 2015 at 7:04 am
On the other side of the same coin...
I won't support change for the sake of change or for the sake of someone being a cool kid that just deployed the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 11:23 pm
So, why did the chicken cross the road? Because he's always done it that way. 🙂 Why won't he stop? Because he's never tried that before. 🙂
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 6:26 pm
Not as convenient as a SELECT INTO, though.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 5:53 pm
... and don't forget to rebuild the indexes on EVERY table because even one-off shrinks are going to fragment the hell out of your database.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 4:35 pm
kingdonshel (8/3/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 4:33 pm
GonnaCatchIT (7/31/2015)
I have a Database say DB1 which has collation "SQL_Latin1_General_CP1_CI_AS".
The tempdb in the sql server is set to collation "Latin1_General_CI_AS".
I have SP's which create temp tables say :#temp1...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 4:32 pm
New persopn (8/3/2015)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 4:26 pm
Matt Miller (#4) (8/3/2015)
Jeff Moden (8/3/2015)
a_ud (8/3/2015)
Thanks Jeff, perfect solution. Testing it now.I also found this explanation, pretty much in the same line, that also seems easy enough:
http://blog.sqlauthority.com/2012/11/20/sql-server-using-rand-in-user-defined-functions-udf/
Thanks for the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 4:14 pm
JaybeeSQL (8/3/2015)
I figure I need to output a sproc into a new physical table, so the column definitions match the output.
So far I think I'll need a
Select Into...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 4:09 pm
Welsh Corgi (8/3/2015)
There are 3 file groups and 6 files.
Not that it will matter much but for what? The database or that one table?
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 10:08 am
Thanks for the feedback folks. I'll start working on the article. Shouldn't be too difficult considering the Power Point "document" I already have on the subject.
Heh... ironically, I...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 10:06 am
a_ud (8/3/2015)
Thanks Jeff, perfect solution. Testing it now.I also found this explanation, pretty much in the same line, that also seems easy enough:
http://blog.sqlauthority.com/2012/11/20/sql-server-using-rand-in-user-defined-functions-udf/
Thanks for the feedback. The problem with...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 3, 2015 at 9:56 am
Viewing 15 posts - 19,981 through 19,995 (of 59,072 total)