Viewing 15 posts - 43,621 through 43,635 (of 49,552 total)
That's not a standard SQL Server error. There's also no way that a select statement alone will give a foreign key/null/unique constraint error. Those can only be thrown by an...
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 22, 2008 at 8:03 am
Where's the primary key?
Do you reload the entire 10.5 million rows every day, or are you doing incremental loads?
With profiler, the default template's pretty good, just make sure 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 22, 2008 at 8:01 am
Upington? There are people living there? 😉
It's a possibility. I'd have to ask MS though, as I have no tools for doing that myself. Also we'd then have to consider...
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 22, 2008 at 2:17 am
What error do you get?
With the variables declared it parses fine. I can't run it, because I don't have your tables
DECLARE @CompanyId int, @AuthRolId int, @UserId int
SELECT tblProjects.ProjectId, tblProjects.ProjectName,...
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 22, 2008 at 2:11 am
The_SQL_DBA (10/21/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 22, 2008 at 2:05 am
Check that your log backups are succeeding.
What's the result of this query for the DB in question
SELECT name, log_reuse_wait_desc from sys.databases
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 22, 2008 at 2:02 am
Mh (10/21/2008)
I am trying to find out sql server related issues in OLTP environment.Please forward me any articles you may have on this. Thanks!
That's a pretty open-ended question. Can...
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 22, 2008 at 1:49 am
MySpace runs on SQL Server, so it's not a case of can SQL handle it, it can, but also the rest of the infrastructure needs serious consideration.
Will your network support...
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 22, 2008 at 1:48 am
DBCC SQLPERF(LogSpace) isn't deprecated in SQL 2008. There's no deprecation notice in BoL and running it doesn't fire a deprecation event for profiler to pick up.
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 22, 2008 at 1:38 am
TheSQLGuru (10/21/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 22, 2008 at 1:35 am
Can you post the table structure and some of the more common queries that are run against it? Use profiler to get an idea of the queries that Access runs...
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 22, 2008 at 1:34 am
Lian Pretorius (10/22/2008)
Thanks Gail - That was awesome!
😀 Glad you enjoyed it.
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 22, 2008 at 1:26 am
Possibly the stats getting inaccurate. Run an update statistics with fullscan and see if that helps.
Post the stored proc's code?
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 21, 2008 at 9:13 am
Eugene (10/21/2008)
After you trace deadlock and get idea what is running (who is victim)you will probably wish to add indexes and try to use NOLOCK hint
I would suggest, once...
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 21, 2008 at 9:07 am
Eugene (10/21/2008)
Hi,You need t enable 2 traces:
DBCC TRACEON (3604)
DBCC TRACEON (1204)
1204 alone is enough. 3604 is used to direct output of some commands to the client. Good example is...
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 21, 2008 at 8:38 am
Viewing 15 posts - 43,621 through 43,635 (of 49,552 total)