Viewing 15 posts - 1 through 15 (of 42 total)
I recently ran across this issue in one of my data conversions for a client. Same error but different symptoms. I was able to narrow the issue down...
January 8, 2011 at 7:20 pm
Other useful info. I found a way to create the linked server without creating a System DSN. I have created a stored procedure that allows you to pass...
December 31, 2009 at 1:43 pm
This is the script for creating a linked server after you have followed the instructions for configuring ODBC and OPENROWSET etc. Replace @datasrc=N'YourODBCDataSource' with the name of your odbc...
December 19, 2009 at 2:10 pm
Looked at the execution plan further. The "bad" query that was doing more logical reads...but it was doing index seeks and loop joins. The "good" query that was...
December 14, 2009 at 2:02 pm
Any suggestions on how to ignore results where the searched for text only occurs as part of a comment?
September 17, 2009 at 11:10 am
Not too long ago, I was working for a subprime mortgage company. I watched the size of our company go from 2500 down to 50. They kept me...
October 1, 2008 at 11:00 am
There are a lot of articles out there on this topic. Search on "perfmon" and you should find what you are looking for.
September 5, 2008 at 10:16 am
Most likely your sql server agent is running under a (Local System) account as opposed to a domain account. You get the same problem if you have a Windows Service...
November 2, 2004 at 5:14 pm
Thanks for the candid response. One thought I have is to do a comparison on the system tables, sysindexes I presume to see where the extra used space is...
November 13, 2003 at 9:26 am
Try turning on sql profiler, opening a new alert dialogue, and see what commands are sent to the db to pull up that screen. Go through them to see...
November 11, 2003 at 9:45 am
This type of manipulation would be better suited for a trigger then a default value. Just use the basic if logic in a trigger to define the values.
November 11, 2003 at 9:41 am
Write a script to pull the table names out of sysobjects where xtype = 'U'. Something to the effect of :
Select 'Truncate Table ' + name
From sysobjects
Where xtype =...
November 11, 2003 at 9:39 am
The Production primary File Group:
FileIDFGrpTotalExtentsUsed Extents
11109408 91567
The Restored primary file group on dif server:
FileIDFGrpTotalExtentsUsed Extents
11109408 46945
...
November 11, 2003 at 9:28 am
Read "Executing a DTS Package" in Books Online. Should cover everything you need to know.
November 10, 2003 at 10:38 am
More information may be helpful...
Is the data the same during the day as it at night? If so, doing it at night makes no sense to do because transactional...
November 10, 2003 at 10:32 am
Viewing 15 posts - 1 through 15 (of 42 total)