Viewing 15 posts - 7,111 through 7,125 (of 26,490 total)
amber.richard (12/2/2013)
San Francisco, CA and this position cannot be done remotely, unfortunately. I like working from home, as well, but this needs to be done onsite 🙂
I took the time...
December 2, 2013 at 11:50 am
When I first started working with SQL Server I was also heavily involved with the hardware and OS (NT 4.0). I was the backup for our SysAdmin and helped...
December 2, 2013 at 8:53 am
dwain.c (12/1/2013)
Lynn Pettis (12/1/2013)
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Personally I have no issue with stores opening on Thanksgiving. The first time...
December 1, 2013 at 5:44 pm
Revenant (11/30/2013)
Steve Jones - SSC Editor (11/30/2013)
Personally I have no issue with stores opening on Thanksgiving. The first time I worked on...
December 1, 2013 at 2:59 am
lukas.eder (11/26/2013)
I have recently blogged about 10 common mistakes Java developers make when writing SQL. These mistakes apply to all other developers (including SQL developers) as well, of course:http://blog.jooq.org/2013/07/30/10-common-mistakes-java-developers-make-when-writing-sql/%5B/url%5D
http://blog.jooq.org/2013/08/12/10-more-common-mistakes-java-developers-make-when-writing-sql/%5B/url%5D
I was...
November 26, 2013 at 4:14 am
Don't know what a TPL file is and since I never had to convert a query using the webtask procedures to SQL Server 2008 the best I could do was...
November 26, 2013 at 12:13 am
This is, obviously, an it depends moment. At a previous employer our 75 GB HR and Finance databases had backup and restore times under 10 minutes. These were...
November 26, 2013 at 12:06 am
Luis, I noticed your output wasn't ordered by Month (Calendar order), so made one more change to the 2008 and newer version:
DECLARE @StartDate date = '20130115',
...
November 25, 2013 at 11:36 pm
Luis Cazares (11/25/2013)
DECLARE @StartDatedate = '20130115',
@EndDatedate = '20130307';
WITH E1(N) AS (
...
November 25, 2013 at 11:22 pm
hunchback (11/25/2013)
November 25, 2013 at 10:50 pm
I notice it thinks you need a nonclustered index as well.
November 25, 2013 at 11:21 am
erikd (11/25/2013)
Lynn Pettis (11/25/2013)
Five, it would be interesting to see how your solution works when adapted to use the actual data source.
Ask and ye shall receive.
The first query plan...
November 25, 2013 at 11:18 am
Unfortunately, there is no way to answer this question as we don't know anything about your databases, application(s), environment to be able to tell you anything. We don't have...
November 25, 2013 at 10:58 am
One, using a table variable isn't necessarily a good choice for testing. No matter how many rows of data exist, the optimizer will assume 1 row as there are...
November 25, 2013 at 10:28 am
erikd (11/25/2013)
November 25, 2013 at 8:35 am
Viewing 15 posts - 7,111 through 7,125 (of 26,490 total)