Viewing 15 posts - 44,071 through 44,085 (of 49,571 total)
So help_publication doesn't show any result set at all?
October 3, 2008 at 1:32 am
To be a little pedantic...
Transaction log backups don't backup changes. They backup a list of operations that occurred since the last log backup, including the time that they occurred. If...
October 3, 2008 at 1:31 am
Hemalatha (10/3/2008)
I have seen reply of using partitions, but tats not the remedy.
Why are partitions not appropriate?
October 3, 2008 at 1:26 am
kotlas7 (10/3/2008)
Hi Gail Shaw,I observed that the Optimization and Intigrity checks jobs are scheduled to run at the same time.
Is this cause to fail the intigrity job?
No.
George said exactly...
October 3, 2008 at 1:23 am
Very little.
A CTE can be considered a 'named' subquery. It means if you need the subquery in more than one place (say in select and where), you can define...
October 2, 2008 at 9:46 am
Change the where clause to what Steve posted. That should sort the query out.
If you post your existing ASP code (just the data access portion) then we can help you...
October 2, 2008 at 9:39 am
PaulB (10/2/2008)
the plot thickens!... there is not such a thing as Bug #6646512 documented on Oracle's Metalink, interesting.
<shrug> I got that info 3rd hand. I wouldn't be surprised if there...
October 2, 2008 at 9:15 am
Great
Do you need help getting it into ASP? Do you want help in turning it into a stored proc? Or is everything sorted now?
October 2, 2008 at 9:11 am
kelly (10/2/2008)
There is just the basic indexes in there, and it's about only 200,000 records
Basic indexes meaning what exactly? Please post the table structure and the index definitions. Remeber that...
October 2, 2008 at 8:52 am
You really should learn stored procedures. They make code more modular (T-SQL in the database and C#/VB in the client app) and they can prevent certain security problems that you...
October 2, 2008 at 8:46 am
a_bennen (10/2/2008)
This makes a little sense. Where do I put the statement in my Query?
What Steve gave is your query. Are you using stored procs (good practice) or ad-hoc SQL...
October 2, 2008 at 8:10 am
AndyD (10/2/2008)
With DB Mirroring, the application must support mirroring. Most commonly, by using an "SQL Native Client" odbc driver.
Indeed. It's a point I forget to mention.
With mirroring it's the client...
October 2, 2008 at 7:55 am
frank.brouwer (10/2/2008)
Hi Gail,Thanks for your response, very interesting article.
Which raises a question right away, is it of any influence on the CPU usage problem?
Thanks,
Frank.
Is what of any influence? The number...
October 2, 2008 at 7:50 am
One other thing to add to Chris's list.
Cursors (from what I understand) are often used in Oracle and are a good way to do things. Not so in SQL Server....
October 2, 2008 at 5:58 am
Do you have replication on the DB?
Is the log shipping running? (are the backups of the log working?
Please don't shout (type in all caps).
October 2, 2008 at 5:57 am
Viewing 15 posts - 44,071 through 44,085 (of 49,571 total)