Viewing 15 posts - 3,811 through 3,825 (of 49,571 total)
A requirement of a relational database system is that a user of the database does not need to know anything about where or how the data is stored. This extends...
January 19, 2016 at 8:38 am
Gary Varga (1/19/2016)
I agree with your sentiments here but that is not the appropriate way to call a stored procedure from .NET.
No kidding, since I posted it as a bad...
January 19, 2016 at 8:27 am
Ed Wagner (1/19/2016)
GilaMonster (1/19/2016)
BL0B_EATER (1/19/2016)
GilaMonster (1/19/2016)
January 19, 2016 at 7:30 am
roger.plowman (1/19/2016)
Stored procedures (and no dynamic SQL in them) are the way to go
No, they're not necessary. Parametrising calls is necessary. That's all.
If the app developer doesn't know what they're...
January 19, 2016 at 7:10 am
BL0B_EATER (1/19/2016)
GilaMonster (1/19/2016)
January 19, 2016 at 6:59 am
If RESTORE DATABASE <db name> WITH RECOVERY doesn't work, then it's probably not in a state where you can restore log backups. It's possible someone accidentally restored over it and...
January 19, 2016 at 5:51 am
Talking about dressing up a CV, the last time I used an agency (well over 10 years ago), they sent me to an interview. At the time I was a...
January 19, 2016 at 5:45 am
Yup, that's an interviewer who's just failed the interview (remember it's a 2-way street, you're evaluating them as much as they're evaluating you)
January 19, 2016 at 4:38 am
About 4 months ago, I got an SMS from a recruiter which said (paraphrased)
"I saw your profile on LinkedIn. One of my clents(sic) is looking for Developers with C# skills....
January 19, 2016 at 4:28 am
Grant Fritchey (1/19/2016)
I'd probably go with the extended events session.
Thirded. I'm starting to love XEs (late to the party, I know).
January 19, 2016 at 1:39 am
The only queries which go to read only replicas are ones that are run on connections which were made with the ReadOnlyIntent option in the connection string. If the connection...
January 19, 2016 at 1:31 am
Please note, 4 year old thread.
Restarting a prod SQL Server to remove a temp table is a tad overkill....
January 19, 2016 at 1:27 am
You can use a CASE statement. It'll be messy, but SQL doesn't have a 'max across columns' function.
January 18, 2016 at 2:00 pm
Providing TempDB's not under IO contention already.
RAID 1 is a mirror. Two drives, each with full copy of the data. Either can fail with no loss of data. I...
January 18, 2016 at 8:48 am
Viewing 15 posts - 3,811 through 3,825 (of 49,571 total)