Viewing 15 posts - 3,871 through 3,885 (of 6,041 total)
Iwas Bornready (5/19/2015)
In our small environment we have one person that does it all. So he'll be talking to himself about our VMs.
Yes, in small companies the IT department is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 19, 2015 at 7:18 am
TrailRunner (5/13/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 19, 2015 at 7:00 am
Post DDL for the table, including the constraints, defaults, and indexes. Also the insert statement.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 2:32 pm
Iwas Bornready (5/18/2015)
What a great idea. I totally agree. Let me see if I can optimize it even more and then force sql to use my version.
Real DBAs hand code...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 2:26 pm
I've never installed SQL Server in a production environment, but I've installed it at dozens of times on my work PC, laptop, and in development. There are several points in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 10:34 am
I googled, and it appears that the Default Trace can be used to track several types of changes to login properties... but not a password change, which would seem to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 9:18 am
Sean Lange (5/18/2015)
Michael L John (5/18/2015)
Jeff Moden (5/18/2015)
andrew gothard (5/18/2015)
Jeff Moden (5/14/2015)
Me, the interviewer: As the Lead Developer on this project, we're very interested in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 8:22 am
When initially creating a stored procedure, I'll sometimes copy / paste text from the functional specification into the header comments.
Also, it helps to include the RFC# or equivalent when...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 7:10 am
Jeff Moden (5/16/2015)
Me: Tell...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 18, 2015 at 6:43 am
David Webb-CDS (5/15/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2015 at 2:11 pm
Sean Lange (5/15/2015)
Luis Cazares (5/15/2015)
Leading...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2015 at 10:42 am
Luis Cazares (5/15/2015)
Leading commas or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2015 at 9:59 am
Grant Fritchey (5/15/2015)
Eric M Russell (5/15/2015)
Grant Fritchey (5/15/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2015 at 9:45 am
Stephanie Giovannini (5/15/2015)
Q: Where do you see yourself in 5 years?
A: CEO!
Background: This young fellow, an...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2015 at 9:14 am
Here are a handful of approaches, listed from what's generally fastest (select / into) to slowest.
Select into a new table (ie: SELECT * INTO B FROM A).
Select into...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 15, 2015 at 8:47 am
Viewing 15 posts - 3,871 through 3,885 (of 6,041 total)