Viewing 15 posts - 661 through 675 (of 1,131 total)
Date and Time of the install of a patch is available in the Windows System Event Log. MS provides a command-line tool, which is part of the Windows 2000 Resource...
SQL = Scarcely Qualifies as a Language
March 9, 2007 at 7:48 am
Perhaps this will work:
select Employee.EmpName
, COALESCE ( EmployeeBudgets.BudgetAmount, 0 ) as BudgetAmount
, COALESCE ( EmployeeExpenses.ExpenseAmt, 0 ) as ExpenseAmt
, COALESCE ( EmployeeBudgets.BudgetAmount, 0 )
- COALESCE ( EmployeeExpenses.ExpenseAmt, 0...
SQL = Scarcely Qualifies as a Language
March 8, 2007 at 9:37 am
Space information is not maintained in real-time but only when indicies are rebuild or "dbcc updateusage" is run.
"dbcc updateusage" can be also be invoked by running:
exec sp_spaceused @updateusage = 'true'
SQL = Scarcely Qualifies as a Language
March 6, 2007 at 6:24 pm
Start with a joke (sort of)
Q: What is the best kind of rock to pound in screws ?
A: Granite
The correct answer is of course, not to use a rock...
SQL = Scarcely Qualifies as a Language
March 6, 2007 at 2:36 pm
You are correct - Using DTS, you cannot update table rows based on rows in an excel spreadsheet.
Instead, use DTS to import the Excel spreadsheet into a table, and then...
SQL = Scarcely Qualifies as a Language
March 6, 2007 at 2:31 pm
The message appears quite clear that the columns named 'Level1' and 'Lvl2' are not valid.
This can mean that the tables/views do not contain these columns or that your login does...
SQL = Scarcely Qualifies as a Language
March 6, 2007 at 2:28 pm
SQL Server Books Online had an update in January 2005, which can be downloaded from:
The MSDN SQL Server documentation for RESTRICTED_USER agrees with Jo Mong's post.
http://msdn2.microsoft.com/en-us/library/aa933082(SQL.80).aspx
SQL = Scarcely Qualifies as a Language
March 6, 2007 at 2:24 pm
"I've found some traces running on our server. I'd like to find out where they are saving the file or table to. how can I do this? "
select...
SQL = Scarcely Qualifies as a Language
March 5, 2007 at 1:02 pm
From Books on Line:
SQL Server requires that the WITH NORECOVERY option be used on all but the final RESTORE statement when restoring a database backup and multiple transaction logs, or...
SQL = Scarcely Qualifies as a Language
March 4, 2007 at 8:14 am
Joe Celko's SQL for Smarties: Advanced SQL Programming is a must read !!!
SQL = Scarcely Qualifies as a Language
March 3, 2007 at 7:54 am
In response to post by Zoran Kovacevic on 3/2/2007 2:56:00 PM CST:
<Have a table with Type and Quantity field like (about 10,000 rec.)and try to make table like
TYPE INPUT ...
SQL = Scarcely Qualifies as a Language
March 2, 2007 at 6:57 pm
I took a look at a cluster that has 3 SQL Server 2000 instances running and found 4 cluster resource groups:
"Cluster group" containing resources Cluster Name, Cluster IP, MSDTC and...
SQL = Scarcely Qualifies as a Language
March 2, 2007 at 5:45 am
"I have recently heard that joining to the largest table last in a query involving several tables can have a performance gain.
Is this true? If so how does this increase...
SQL = Scarcely Qualifies as a Language
March 2, 2007 at 4:09 am
Would not a foreign key contraint be easier ?
Assuming that ORDER_TYPE_ID and ORDER_SUB_TYPE_ID are the primary key of table ORDER_SUB_TYPE_LOOKUP:
Alter table ORDER_MASTER
add constraint ORDER_SUB_TYPE_LOOKUP_FK_ORDER_MASTER
foreign key (ORDER_TYPE_ID ,ORDER_SUB_TYPE_ID )
references ORDER_SUB_TYPE_LOOKUP
go
SQL = Scarcely Qualifies as a Language
March 1, 2007 at 5:40 pm
Have you compared the write cache options on both servers?
Use Device Manger, Disk Drives, select a disk, right click ==> properties and then select the "Disk Properties" tab. Is...
SQL = Scarcely Qualifies as a Language
March 1, 2007 at 2:26 pm
Viewing 15 posts - 661 through 675 (of 1,131 total)