Viewing 15 posts - 44,056 through 44,070 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2008 at 5:57 am
llevity (10/1/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2008 at 5:54 am
They might. I've never used them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2008 at 5:47 am
blake colson (10/1/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2008 at 5:46 am
kotlas7 (10/1/2008)
Iam getting the message 'The command(s) completed successfully'No errors occurred. Is there any other DBCC commands to check The data and index linkage?
Then you have no corruption. That's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2008 at 5:45 am
Viewing 15 posts - 44,056 through 44,070 (of 49,552 total)