Viewing 15 posts - 3,571 through 3,585 (of 6,041 total)
Sean Lange (8/13/2015)
SQLRNNR (8/13/2015)
Grant Fritchey (8/13/2015)
caojunhe24 (8/12/2015)
#temp is much more useful than @tempReally? What about in the case of recompiles?
Or a user-defined table type?
Better yet...
A user defined memory optimized table...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 2:57 pm
Long overdue praise for the lowly tally table. I declare August 33rd as the official Tally Table Appreciation Day.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 2:52 pm
Grant Fritchey (8/13/2015)
Eric M Russell (8/13/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 12:28 pm
Generally speaking:
Table variables have scope limited to what one would expect with other types of variables, and it allow for fixed plans, which is a strong and compelling reason to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 12:14 pm
SQL Azure should be technically up to the task. However, my understanding is that you get billed based on network transfer fees. How many GB total of data do you...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 11:50 am
Luis Cazares (8/13/2015)
Eric M Russell (8/13/2015)
Luis Cazares (8/13/2015)
Ed Wagner (8/13/2015)
Eric M Russell (8/13/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 7:54 am
Luis Cazares (8/13/2015)
Ed Wagner (8/13/2015)
Eric M Russell (8/13/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 7:40 am
sumit4bansal (8/5/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 7:34 am
A tally table (or tally set because it's not always a table) is useful for those scenarios where you need to stub in gaps for a resultset. For example, the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 13, 2015 at 6:59 am
TheSQLGuru (8/12/2015)
Eric M Russell (8/12/2015)
TheSQLGuru (8/9/2015)
...There are many other CRUD generators out there too, including free options. SSMS can do it even, albeit one at a time.
Where is this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2015 at 3:01 pm
TheSQLGuru (8/9/2015)
...There are many other CRUD generators out there too, including free options. SSMS can do it even, albeit one at a time.
Where is this feature in SSMS?
It would...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2015 at 6:43 am
ssk7317 (8/6/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 11, 2015 at 2:38 pm
mister.magoo (8/6/2015)
Perhaps you should just...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 11, 2015 at 2:32 pm
You can provide business with an equation like the following:
Bytes of Storage =
{? avg orders per day}
X {? avg items per order}
X {? number of days}
X...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 11, 2015 at 1:32 pm
Here is something I wrote the other day to grab DB_NAME, LOGIN_NAME, DB_ROLE for all databases on the instance.
if object_id('tempdb..#db_roles') is not null drop table #db_roles;
create table #db_roles
(
primary...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 11, 2015 at 10:55 am
Viewing 15 posts - 3,571 through 3,585 (of 6,041 total)