T-SQL is Microsoft's procedural language to control SQL Server.

By way of comparison, PL/SQL is Oracle's procedural language to control Oracle.

They're not interchangeable.

You use both do do DDL, DML and administration....

Now that's a pretty cool idea I hadn't even considered. What's the performance like when compared to a physical table? I haven't tried it, but I'd imagine that,...

I've heard the tally table described as the "Swiss Army Knife of SQL" by more than one person on this site. It can solve a lot of problems and...

Let me first say that I don't know MySQL.

That being said, your field name "duration" as an integer makes me stop and think. I presume that you're storing the...

I would go with querying the system tables to get the rows you need. Besides, who knows if sp_help is going to change from version to version? Granted,...

While I haven't gone through the stairway on SQL DML, I found the one on indexing and the one on transaction log management to be quite good. If those...

I like to treat the SSMS time shown in the status bar as a general guide for how long a whole process takes and nothing more. I much prefer...

WOW! I don't know if there's a way to recover from that. Given that all the accounting numbers would have to be redone for each week and month since...

Is the job enabled and scheduled? Has it ever run successfully where you should have received an email?

I don't get the exact reason for it either; perhaps somebody else does. I was just describing the workaround we use to solve the problem. I've never found...

I would start by examining the queries executed to generate the report. Since they haven't changed, I wouldn't expect that performance would improve too much. You might have...

I've seen this before. The import process is recognizing the empty string in the source data. Your destination data type is numeric, so the import process replaces the...

I think you need to have the VIEW SERVER STATE permission to see the CPU graph in activity monitor.

I believe that the default schema for the user is checked for the existence of an unqualified table name, then the dbo schema is checked. I don't know why...

I think that education is the first step in becoming good at something, but it is only the first step. Honestly, I would take the courses that will teach...