Viewing 15 posts - 5,521 through 5,535 (of 49,552 total)
sault (6/22/2015)
They never import or write the data into the main database unless a manual backup is done.
Seriously, you need to spend some time reading up on what...
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 23, 2015 at 2:47 am
SQLRNNR (6/22/2015)
GilaMonster (6/22/2015)
Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
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 23, 2015 at 2:38 am
Eirikur Eiriksson (6/22/2015)
GilaMonster (6/22/2015)
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 22, 2015 at 1:48 pm
Luis Cazares (6/22/2015)
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 22, 2015 at 1:47 pm
sault (6/22/2015)
I am still back to how do I stop it.
Once more with feeling...
GilaMonster (6/22/2015)
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 22, 2015 at 1:41 pm
How many rows in the temp table?
What does that function do?
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 22, 2015 at 10:08 am
That's not SQL Server code.
This is a Microsoft SQL Server site, we're not going to be much help in writing triggers and functions for Oracle. Maybe try an Oracle-focused...
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 22, 2015 at 9:37 am
Post the information here. Not as an image, as something people who are interested in helping you can copy, run and use to test any code they write.
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 22, 2015 at 9:28 am
Need more information.
Table definitions please, sample data, examples of the data modifications that will fire the triggers and details of what you want the triggers to do to the 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 22, 2015 at 9:20 am
sault (6/22/2015)
But I do need to find a fix.
Check the scheduling for the 3rd party backup tool. SQL does not control the frequency of backups, if there are...
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 22, 2015 at 9:19 am
https://www.google.com/?gq=What+is+an+access+violation
First result I get is an MSDN blog post explaining what an access violation is.
And no, nothing to do with resource contention. It's a severe error relating to illegal memory...
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 22, 2015 at 9:14 am
A CTE isn't a temp table, it's visible to the query (singular) that immediately follows it, that's all. Not the rest of the batch.
-- update 1
WITH X_SET_PREOP
...
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 22, 2015 at 9:12 am
Err, there's no such version as SQL 2003.
You mean SQL 2005?
See http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ for saving execution plans.
For the index definitions, you can see them in Management Studio, should be same place...
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 22, 2015 at 8:55 am
No, not 'a large number of log files being backed up', a large number of log backups. Very, very different thing.
Check the scheduling for the 3rd party backup tool. 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 22, 2015 at 8:52 am
It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire Saturday because someone...
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 22, 2015 at 8:39 am
Viewing 15 posts - 5,521 through 5,535 (of 49,552 total)