Viewing 15 posts - 631 through 645 (of 708 total)
If the Details table is usually accessed this way, I'd try changing the clustered index to MasterID, Value. If that isn't your primary key on that table (such as if...
May 4, 2006 at 11:13 am
Reports are coming in from people who took 71-442 at VUE centers are starting to get results. However, no results have been reported to those who took the test at...
May 3, 2006 at 12:52 pm
If the purpose of this test server will be to decide if SQL Server will be used at all, then SQL Server is being evaluated, and the eval edition is appropriate.
However, if...
May 3, 2006 at 12:48 pm
http://www.microsoft.com/sql/howtobuy/default.mspx
You do not license connections to SQL Server. You license either (for SQL Server - the Win2003 license is separate and unrelated):
1. Per processor for unlimited clients from unlimited devices
-...
May 3, 2006 at 12:18 pm
The eval version is not licensed for any purpose other than evaluation of the product. If you are testing your code before it moves to a production SQL Server, then...
May 3, 2006 at 12:13 pm
I haven't, and none of the other folks I know who took have, either.
It hasn't even been 2 months since the beta period closed. Give a few more weeks.
I'll...
April 26, 2006 at 12:22 am
Developer Edition is a license for a single user. If multiple users will be testing against the test server, they each will need a Dev Edition license.
There is no distinction...
April 25, 2006 at 11:49 pm
This query should get you started:
SELECT c.TABLE_SCHEMA, c.TABLE_NAME, c.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS c INNER JOIN
INFORMATION_SCHEMA.TABLES t ON t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME
WHERE t.TABLE_TYPE... April 25, 2006 at 11:02 am
0x0a (hexadecimal) = decimal 10
char(10) = line feed
select 'A' + convert(char(1),0x0a) + 'B'
is the same as
select 'A' + char(10) +
April 25, 2006 at 10:49 am
When using the udf like this:
UPDATE #final SET
intl_codes1 = dbo.GetInternationalCodes( award_id)
you're still performing row-by-row actions, and hopping off to a separate function each time to...
April 21, 2006 at 11:01 am
You can also take a look into using XML templates to present query results through the SQLXML IIS plugin. Query + FOR XML + XSLT = web page
Marshall's suggestion of...
April 20, 2006 at 10:26 am
I would advise writing a stored procedure to do the work, and grant access to the procedure.
You could include checks in the procedure so it only works in a certain...
April 20, 2006 at 10:21 am
1. When a procedure is named sp_<name> (or dbo.sp_<name> ), SQL Server will search for it in the Master database before searching in the current database. If you have a server...
April 20, 2006 at 5:43 am
If I'm reading this right...
You don't need the DISTINCT statement, the GROUP handles that.
To filter on aggregates after the grouping, use the HAVING clause:
SELECT hist.ConsultancyID FROM ben_vw_consultancy_history hist...
April 19, 2006 at 3:20 pm
Go for DBA if you want to be a DBA. The talent pool and market needs change often enough that by the time you're really good at it, the money...
April 15, 2006 at 11:30 am
Viewing 15 posts - 631 through 645 (of 708 total)