Viewing 15 posts - 3,811 through 3,825 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2016 at 7:30 am
Parallelism.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2016 at 7:16 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 19, 2016 at 7:10 am
BL0B_EATER (1/19/2016)
GilaMonster (1/19/2016)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 18, 2016 at 8:48 am
Viewing 15 posts - 3,811 through 3,825 (of 49,552 total)