Viewing 15 posts - 12,571 through 12,585 (of 49,552 total)
Please run the following and post the full and unedited output
DBCC CheckDB(<database name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
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
June 26, 2013 at 2:15 am
In my experience, the SAN admin almost always says there's nothing wrong even when the SAN is clearly, obviously and provably the problem.
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
June 26, 2013 at 2:08 am
There's nothing magical about a SAN that means it's not the problem. In fact, it's very likely it is the SAN, a misconfigured SAN.
Check the throughput you're getting from the...
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
June 26, 2013 at 1:50 am
Chad Crawford (6/25/2013)
Yikes. I often tell people, "I only know one language, but I'm not fluent". Now I have even more reason to do so.
My ability with...
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
June 25, 2013 at 3:12 pm
No idea about Swahili, since it's not native to my neck of the world, but Zulu is correctly written as isiZulu when writing in the language, not Isizulu. It's similar...
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
June 25, 2013 at 2:21 pm
Meet George Jetson (6/25/2013)
I was able, finally, to get the client's IT to install SS 2008 R2 Express,
SQL Server 2008 R2 Express is NOT the same thing as 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
June 25, 2013 at 1:55 pm
YEs, you can restore just the primary filegroup from the backup, even if it's the full database backup.
Look up the RESTORE DATABASE syntax, you're looking for the FILEGROUP = option,...
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
June 25, 2013 at 1:50 pm
What you have there is near-impossible to interpret. It's executing a query that was prepared earlier with sp_prepexec (or maybe sp_prepare, can't recall details here). The "N'myapplication.POL_SUPRES_ISS_IND'" is simply a...
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
June 25, 2013 at 5:31 am
Not repairable in any way.
Since you have no backup...
Script all objects (some may fail)
Export all data (some will likely fail)
Recreate the database.
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
June 25, 2013 at 4:48 am
You have slow IO requests. Check that the IO subsystem is not overloaded, try tuning queries to read less data.
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
June 25, 2013 at 4:47 am
michal.lisinski (6/25/2013)
2. Check size of data sets inserted to the temp tables, if they are small (few rows), use varaible table.
Disagree there, table variables are not magically faster than temp...
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
June 25, 2013 at 3:19 am
Please post new questions in a new thread and give as much information example as possible, including exact error messages, anything unusual in the error log, etc.
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
June 24, 2013 at 2:27 pm
You shrunk a database? How could you???
:hehe:
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
June 24, 2013 at 1:42 pm
No, raiserror doesn't log to some other log file or system table. If the error is high enough severity or with the WITH LOG option, then it goes into the...
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
June 24, 2013 at 1:41 pm
And this is why you should always, always, always qualify column names with the table name when you have subqueries around.
This will fail.
DELETE
FROM dbo.DimCustomer_LLF AS DCust
WHERE DCust.CustomerKey in (SELECT DISTINCT(CS.CustomerKey)...
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
June 24, 2013 at 1:37 pm
Viewing 15 posts - 12,571 through 12,585 (of 49,552 total)