Viewing 15 posts - 4,186 through 4,200 (of 6,041 total)
In some organizations, because of the way the pay grades and scales are structured, getting promoted to management is the only way for a senior level IT employee to get...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 6, 2015 at 8:11 am
First, I'm assuming that these user login accounts are properly assigned as members of default [public] server role and NOT [sysadmin]. There is nothing you can do to hide things...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 5, 2015 at 3:37 pm
I also got my start back in late 80s and early 90s working with FoxPro and dBase on DOS, and later Clipper on OS/2. I thought I could build an...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 5, 2015 at 9:45 am
Try all three methods (CASE, ISNULL, and COALESCE) and see which is faster in your specific scenario. If you're encountering performance issues, then it's probably the sargability of the query...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2015 at 10:07 am
He may also want to consider placing a unique key constraint on session + product + time or date with the ingore_dup_key option set to insure that redundant click events...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2015 at 6:42 am
Jeff Moden (2/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2015 at 6:26 am
There seems to have been a spike in career oriented editorials and posts over the past year. I know it's been on my mind a lot lately too.
As for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2015 at 4:26 pm
MMartin1 (2/3/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2015 at 1:23 pm
sys.sysprocesses is legacy, and there are a handful of DMVs that could do the same job better.
The following will simply return number of connections.
select * from sys.dm_os_performance_counters
where Counter_Name =...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 2, 2015 at 8:44 am
Doctor Who 2 (1/31/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 2, 2015 at 7:45 am
David.Poole (1/31/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 2, 2015 at 7:39 am
sm_iransoftware (1/31/2015)
I want to do some thing on this database.
First Of All , I should start with a small database.
But current DB has many connection from site. And I...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 2, 2015 at 7:20 am
RonKyle (1/29/2015)
In a POS system, someting like a terminal_id (origination) + timestamp could be a natural key
I don't want to get in a back and forth about what a natural...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 29, 2015 at 9:41 am
RonKyle (1/29/2015)
In the RDMS realm, it makes more sense for a number of reasons to use a business assigned origin code and timestamp combined to form a natural key.
[Emphasis...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 29, 2015 at 8:37 am
ScottPletcher (1/29/2015)
TomThomson (1/28/2015)
Eric M Russell (1/27/2015)
andrew gothard (1/27/2015)
Eric M Russell (1/21/2015)
However, I would take issue with...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
January 29, 2015 at 8:13 am
Viewing 15 posts - 4,186 through 4,200 (of 6,041 total)