Click here to Skip to main content
14,740,592 members
Home » Discussions » Database
   

Database

 
GeneralRe: Table Design Suggestion Pin
Manish K. Agarwal10-Dec-17 18:53
MemberManish K. Agarwal10-Dec-17 18:53 
AnswerRe: Table Design Suggestion Pin
Mycroft Holmes9-Dec-17 1:00
professionalMycroft Holmes9-Dec-17 1:00 
QuestionCan the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 5:14
professionalRichard Andrew x646-Dec-17 5:14 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Richard Deeming6-Dec-17 10:51
mveRichard Deeming6-Dec-17 10:51 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:16
professionalRichard Andrew x646-Dec-17 13:16 
AnswerRe: Can the Pivot operator be used with text columns? Pin
Jörgen Andersson6-Dec-17 11:05
professionalJörgen Andersson6-Dec-17 11:05 
GeneralRe: Can the Pivot operator be used with text columns? Pin
Richard Andrew x646-Dec-17 13:17
professionalRichard Andrew x646-Dec-17 13:17 
QuestionSQL and database tutorials Pin
MikeTheFid4-Dec-17 12:52
MemberMikeTheFid4-Dec-17 12:52 
This is a call for resources.

I have been to 2 interviews recently and totally blew the technical written tests that involved SQL and SQL Server.

Though I've used SQL and done database design in the past, my current role hasn't afforded me any substantial experience in the last 5 or 6 years.

Can you recommend any books or online courses on SQL, T-SQL, and SQL Server programming to get me back up to speed?

I was on Amazon and found a bunch, but I figure you people would know better. Smile | :)
Cheers,
Mike Fidler

"I intend to live forever - so far, so good." Steven Wright
"I almost had a psychic girlfriend but she left me before we met." Also Steven Wright
"I'm addicted to placebos. I could quit, but it wouldn't matter." Steven Wright yet again.

AnswerRe: SQL and database tutorials Pin
Mycroft Holmes4-Dec-17 14:17
professionalMycroft Holmes4-Dec-17 14:17 
GeneralRe: SQL and database tutorials Pin
MikeTheFid5-Dec-17 1:33
MemberMikeTheFid5-Dec-17 1:33 
QuestionSQL SERVER script Pin
Member 135516041-Dec-17 0:08
MemberMember 135516041-Dec-17 0:08 
AnswerRe: SQL SERVER script Pin
Richard MacCutchan1-Dec-17 0:31
mveRichard MacCutchan1-Dec-17 0:31 
AnswerRe: SQL SERVER script Pin
Simon_Whale4-Dec-17 6:33
professionalSimon_Whale4-Dec-17 6:33 
QuestionSchedule a trace file in SQL Profiler Pin
VK1928-Nov-17 8:06
MemberVK1928-Nov-17 8:06 
AnswerRe: Schedule a trace file in SQL Profiler Pin
Richard Deeming28-Nov-17 8:27
mveRichard Deeming28-Nov-17 8:27 
AnswerRe: Schedule a trace file in SQL Profiler Pin
jschell1-Dec-17 9:01
Memberjschell1-Dec-17 9:01 
GeneralRe: Schedule a trace file in SQL Profiler Pin
VK194-Dec-17 3:17
MemberVK194-Dec-17 3:17 
GeneralRe: Schedule a trace file in SQL Profiler Pin
jschell5-Dec-17 11:24
Memberjschell5-Dec-17 11:24 
GeneralRe: Schedule a trace file in SQL Profiler Pin
VK196-Dec-17 4:39
MemberVK196-Dec-17 4:39 
GeneralRe: Schedule a trace file in SQL Profiler Pin
jschell8-Dec-17 9:14
Memberjschell8-Dec-17 9:14 
QuestionFatal error: Out of memory (allocated 408944640) (tried to allocate 805306376 bytes) Pin
Mahtabpi25-Nov-17 0:11
MemberMahtabpi25-Nov-17 0:11 
AnswerRe: Fatal error: Out of memory (allocated 408944640) (tried to allocate 805306376 bytes) Pin
Richard MacCutchan25-Nov-17 1:14
mveRichard MacCutchan25-Nov-17 1:14 
GeneralRe: Fatal error: Out of memory (allocated 408944640) (tried to allocate 805306376 bytes) Pin
Mahtabpi27-Nov-17 23:49
MemberMahtabpi27-Nov-17 23:49 
GeneralRe: Fatal error: Out of memory (allocated 408944640) (tried to allocate 805306376 bytes) Pin
Richard MacCutchan28-Nov-17 0:26
mveRichard MacCutchan28-Nov-17 0:26 
AnswerRe: Fatal error: Out of memory (allocated 408944640) (tried to allocate 805306376 bytes) Pin
jschell27-Nov-17 11:01
Memberjschell27-Nov-17 11:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.