Viewing 15 posts - 826 through 840 (of 984 total)
Steve Jones - SSC Editor (12/14/2015)
I've been solving them in Python and PoSh, practicing some code. Thought some of you might have fun...
December 15, 2015 at 3:31 am
Steve Jones - SSC Editor (12/11/2015)
Take this week's survey. don't look anything up, first thing that comes to mind. Be serious, not silly.
#10? Really? Why not just ask...
December 11, 2015 at 2:56 pm
Steve Jones - SSC Editor (12/9/2015)
December 11, 2015 at 9:20 am
rodjkidd (12/11/2015)
ThomasRushton (12/10/2015)
Pity they can't seem to stabilise the date...
December 11, 2015 at 6:05 am
Given that an asynchronous member of an availability group could be classed as eventually consistent, quite a few of us...
Me, for one.
December 11, 2015 at 1:33 am
Grant Fritchey (12/10/2015)
Grant Fritchey (12/10/2015)
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad thing would be the...
December 11, 2015 at 1:27 am
Once again, SQL Bits has been announced and I have other commitments that week that I really can't get out of.
Pity they can't seem to stabilise the date of this...
December 10, 2015 at 8:54 am
kenny 40254 (11/30/2015)
We need to schedule jobs, so the Express edition is not going to work..
It is possible to schedule tasks to run without using the SQL Agent task....
December 2, 2015 at 1:53 am
Other free formatting websites are available - http://www.format-sql.com (from Red Gate), or http://www.sql-format.com (from DevArt)
Take your pick. But be consistent - they all have their own rules. Unlike...
November 30, 2015 at 3:07 am
Ed Wagner (11/23/2015)
Brandie Tarvin (11/23/2015)
I have the simplest error-handling method in the universe:Is there an error?
DROP DATABASE <problemDB>;
Done.
I like that. Perhaps a more individualized approach would be to drop...
November 24, 2015 at 1:22 am
Steve Jones - SSC Editor (6/17/2013)
This week is the first SQL in the City of 2013. Anyone coming?
Yup. I'll see you in London on Friday. Looking forward to...
June 18, 2013 at 7:42 am
Assuming you have a table with columns such as PlayerName, Match, Score, then something like:
SELECT PlayerName,
SUM(CASE WHEN Score > 50 THEN 1 ELSE 0 END)...
November 9, 2012 at 5:21 am
Working backwards...
TLog backups - I've found in the past that it can help to increase the frequency of TLog backups during heavy index maintenance from, say, hourly to every minute.
As...
October 26, 2012 at 5:39 am
Are you saying that you only need to SELECT the data WHERE cAbsenceCode = 'P' OR cAbsenceCode= 'S'? and ORDER the results BY dtEnrollmentDate?
October 24, 2012 at 7:34 am
This appears to do what you want:
use tempdb
go
declare @testtable table (id int, value int, name char(4))
insert into @testtable values
(1, 10, 'test'), (2, 5, 'prod'), (3, 10, 'test'), (4, 4, 'test'),...
October 24, 2012 at 5:21 am
Viewing 15 posts - 826 through 840 (of 984 total)