Hello, Is it possible to set SQL 2005 to listen to two ports on the same IP address, or do I need to add an IP address to connect on the alternate...
Is there any software out there that can calculate the size of each table and tell me which tables are using the most disk space?
I was told that a database that I sometimes work with is going to be "locked down" so that special permission is needed to access it (only supported...
I have a table where I need to group by a field, and some of the columns are defined as a bit. What is the best way to handle this situation, or am I...
I was playing with some code found here: http://www.sommarskog.se/arrays-in-sql.html Particularly this function: CREATE FUNCTION...
I have a record that was somehow deleted out of the database. I am not sure how it happened, and that is another story... Anyway, from a previous...
I am trying to write a user defined function to return a table. I can't get it to work as a UDF, but I can get it to work as a stored procedure:...
I need to extract some data from SQL using a stored procedure that I'm running from a SQL job. I have it set to write the results to a text file....
This might be an easy question, but I've never seen this done before and I was wondering how it works. I've found a query that I need to modify, but...
<font face="Tahoma"><br /><font size="2"><br />Hello,<br /><br />I have a question on the best way to do a particular SQL query. This is the basic...
In terms of performance, what do you think is the best way to restrict access to data within an application? For example, lets say you have buyers...
Is it considered poor database design if you don't define relationships in your database? What are the pros/cons? Is there an article here that...
Separate names with a comma.
