Server: Msg 8621, Level 17, State 1, Line 1 Internal Query Processor Error: The query processor ran out of stack space during query optimization.I got the above error when I tried to delete row from a specific table(delete from test.settings where id = 10054; ), that table has too many foreign keys (1009 FK's), so […]
2004-12-21
1,388 reads
2004-12-21
Or... UPDATE YourTable SET YourColumn = STUFF(YourColumn, CHARINDEX(YourColumn, 'mkpdc'), 5, 'SRV01')
2004-11-08
In addition to the fact that it takes less time to spin up on the Reporting Services, I trust the Database Driver for SQL to release connections (which I've been having no end to problems with Crystal), more of our people are familiar with the Visual Studio environment, etc, etc. Makes it more cost effective […]
2004-07-23
2 reads
It happened again, this time I pressed CTRL SHIFT ESC to open the Task Manager and found and killed the hidden Excel process.
2004-07-15
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/sqlserver
2004-06-29
5 reads
Try shrinking it using the fileid (SELECT NAME, FILEID FROM SYSFILES), use the same syntax, just replace the filename with the fileid.
2004-04-14
2 reads
Hi David,I like what you did with the query. It looks much "cleaner" than before. However, I get the following message: Line 59 (highlighted): Incorrect syntax near 'Daily Total'Thank you.CREATE PROCEDURE MTDPerformance3 ASSELECT department, [Date], SUM(CASE [Product] WHEN 'E-Tech' THEN [output] else 0 END) as 'E-TECH', SUM(CASE [Product] WHEN 'E-9' THEN [output] […]
2004-04-14
I would run sp_who2 to check what processes are using up CPU and if any blocking is happening. If you have the money, I would recommend using NetIQ's DiagnosticManager. It monitors real time stats on your server and it also has a feature callew Worst Performing Queries/Stored Procedures/Batches. It actually tells you the queries that […]
2004-04-14
2004-04-14
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers