Viewing 15 posts - 226 through 240 (of 1,131 total)
The rules for the schema appear to be:
A task is a "master" task when the "AssoId" is NULL
A Sub-Task of a master task is identified by the constant "s" preceeding...
SQL = Scarcely Qualifies as a Language
May 31, 2009 at 11:03 am
You can customize the action to be taken by a hot-key including removing the association.
From the menu, pick "tools" , "customize" and then the "keyboard" tab. From the list,...
SQL = Scarcely Qualifies as a Language
May 31, 2009 at 9:49 am
If all of the user databases are in full recovery mode, then full backups could be made earlier (starting at 6PM?), and then at 7 PM, only transaction log backups...
SQL = Scarcely Qualifies as a Language
May 30, 2009 at 7:57 am
Below are three sets of SQL statements that show that when an index is rebuilt or all indexes on a table are rebuilt, column statistics not associated with the indexes...
SQL = Scarcely Qualifies as a Language
May 28, 2009 at 6:35 pm
How about "Value Added" ? Which actually means "we only do those activities that we are obligated to perform based on the contract"
With my collegues, I also...
SQL = Scarcely Qualifies as a Language
May 27, 2009 at 8:03 am
Utopia - Also in a software perspective (We are progressing our software to a utopia)
What makes that buzzword extremely funny is that Utopia means "no where" :-D. Origin is...
SQL = Scarcely Qualifies as a Language
May 27, 2009 at 7:59 am
Error 7884 is an invalid network packet, so check out the NICs to insure that
the latest drivers are installed and that "link speed & duplex" are a fixed value...
SQL = Scarcely Qualifies as a Language
May 24, 2009 at 7:29 am
1. Would I need a new virtual name and virtual ip for the new instance?
Yes
2. I have a separate lun allocated for the new instance, does it need to be...
SQL = Scarcely Qualifies as a Language
May 24, 2009 at 6:59 am
Found that a state of 3 means "maximum user connections exceeded" and the value can be checked by running
exec sp_configure 'user connections'
SQL = Scarcely Qualifies as a Language
May 21, 2009 at 12:26 pm
User Debbie.Smith that exists in group [IT-ABC Production Infastructure Users] can not log in and work. It either gives her a connection failed SQLState: 28000 sql server error 18456 error....
SQL = Scarcely Qualifies as a Language
May 21, 2009 at 12:12 pm
Login names are stored as NVARCHAR(128) , so that is probably not the problem.
There could be a problem when the following occurs:
1. An AD Group is created
2. The...
SQL = Scarcely Qualifies as a Language
May 21, 2009 at 9:54 am
There is the possibility that the AD Account is in more than one AD Group, which can create a problem. You can get the AD groups with this SQL
exec...
SQL = Scarcely Qualifies as a Language
May 20, 2009 at 6:29 pm
Possibly a SQL Parser problem along with an implicit datatype conversion
SELECT 1.1Number11
Which has results with a column name of "Number11" having a numeric value of "1.1"
Looks like the...
SQL = Scarcely Qualifies as a Language
May 20, 2009 at 11:41 am
This problem can be caused by a 3rd-party file encryption solution or if NTFS compression is being used.
Also see http://support.microsoft.com/kb/926070
Error messages may be logged in the SQL Server error log...
SQL = Scarcely Qualifies as a Language
May 19, 2009 at 8:56 am
http://www.tpc.org has various database benchmarks for OLTP and Data warehousing.
TPC-C simulates a complete computing environment where a population of users executes transactions against a database. The benchmark is centered around...
SQL = Scarcely Qualifies as a Language
May 18, 2009 at 8:56 am
Viewing 15 posts - 226 through 240 (of 1,131 total)