...or TOP (n) PERCENT

Ed Wagner (1/14/2013)

---

In SQL Server, you could use the following:

SELECT 'Your performance is ' + CONVERT(Varchar, grade);

I would consult the MySQL documentation under "string concatenation" for details on how it's...

Steven Willis (1/14/2013)

---

...if for some reason additional keys are deemed necessary for a temp table care must be taken to make sure the keys have unique names. For example:

DECLARE

...

paul.j.kemna (1/14/2013)

---

A user on another forum suggested that I dump the error output into a text file.

I did this and I believe it has shed some light on the...

I do not work with DB2 much and am not sure how great the driver is or how well the engine reports its own metadata when SSIS asks. Does DB2...

The SSIS package definitions are stored in msdb.dbo.sysssispackages. Because the definition is XML you can cast it to the XML data type and then operate on it using XQuery. A...

Output. External is just what SSIS thinks the source is.

If you download this SQLCLR component...

http://groupconcat.codeplex.com/%5B/url%5D

...then you can write code like this in SQL Server very similar to what you would expect to be able to write in MySQL. Adding...

Jeff Moden (1/13/2013)

---

bobd125 (1/10/2013)

---

I have a Execute T-SQL task which purged records from table. I would like to record in a log file the record count of how many...

I like to check to see how many CPUs are online as well:

-- cpu overview

SELECT osi.cpu_count AS LogicalCpuCount,

osi.hyperthread_ratio AS HyperthreadCoreRatio,

...

I meant in the Linked Server node in SSMS Object Explorer, under Providers, right click MSDASQL and go to Properties. What do you have setup for options?

That's solid. I meant to come back to this because using RANK seemed clunky and I knew there had to...

You're quite welcome. I am happy it helped.

Jeff Moden (1/13/2013)

---

Hmmm. I can see your point. I mean about not doing file handling in SQL Server and that those types of things should be done well...

It depends on the fillfactor. If you chose 80% you may not want to perform maintenance if page density is at 75%.