Viewing 15 posts - 1,111 through 1,125 (of 1,131 total)
Since the desktop had only one drive, there could be no RAID, so the server RAID configuration will definitely slow performance.
Did the desktop have an IDE Drive ? If so, be aware...
March 8, 2005 at 4:14 pm
Are you aware of stored procedure "parameter sniffing" ? That is, when the stored procedure is first invoked, the query plan is created based on the values of the passed...
March 8, 2005 at 3:46 pm
In the future, please post create table statements including all primary key and foreign key constraints such as:
Create table Customer
(ID integer not null
, DateCreated datetime not null
, CurrentStatus varchar(40) not...
March 8, 2005 at 9:13 am
Since the diagrams are saved in table dtproperties in each database, you could copy the data from one database to another. Here is an example which has been tested:
set identity_insert <targetdb>.dbo.dtproperties...
March 8, 2005 at 8:51 am
Look in Books OnLine for sp_add_jobstep where the specifaction for the @command can include one or more of the case-sensitive tokens which are replaced at run time. These token are not...
March 3, 2005 at 3:11 pm
Try creating a table (named "sequences"  with all numbers between 0 and 32767 as detailed below.
Your actual query can then reference this "sequences" table such...
March 2, 2005 at 12:58 pm
This is untested, but since you have already hacked the system tables, try this:
In sp_addlogins, there is a section of code:
if @encryptopt = 'skip_encryption_old'begin select @xstatus = @xstatus | 0x800, -- old-style...
if @encryptopt = 'skip_encryption_old'
select @xstatus = @xstatus | 0x800, -- old-style...
March 2, 2005 at 12:22 pm
<so the GUI is my crutch! >
Yes, it gets quite complicated using T-SQL but being unable to reproduce your actions...
March 2, 2005 at 11:24 am
1. Are you getting this error ?
Server: Msg 18452, Level 14, State 1, Line 1Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
March 1, 2005 at 4:11 pm
For SQL Server 7.0, the samples (which are an option when installing) has the TEXTCOPY.exe From Books On Line:
TextCopy is a Microsoft Foundation Class (MFC) C++ example that illustrates...
March 1, 2005 at 12:58 pm
exec master.dbo.xp_msver 'PhysicalMemory'
March 1, 2005 at 12:21 pm
Please be sure to post the DDL for 1 of the tables & its indexes, along with a sample SQL update statement. Does the table have a unique clustered index...
February 28, 2005 at 4:19 pm
Regarding the differences between the same query having major differences in response times on different servers, this could be a problem with the physical database such as out of date...
February 28, 2005 at 1:17 pm
I have used SQLIOStress many times to prove hardware configuration problems. What specifically to you want to know ?
Regarding "Same or near similar spec drives etc and some are just...
February 28, 2005 at 11:36 am
Having a single column containing two pieces of information (the value and the sequence within the value) is a violation of the rules of normalizatoim...
February 28, 2005 at 11:09 am