Viewing 15 posts - 31,756 through 31,770 (of 49,552 total)
Post the query?
If you're using that on a column of the table, you're preventing index seeks. That goes for UDFs and most built-in functions as well. Using a function on...
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
July 19, 2010 at 3:48 am
Do I assume that the answer to 'Do you know how to write an update statement' is No?
It's easy enough to set the modified date after an insert or update....
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
July 19, 2010 at 3:30 am
Depends how they're used.
Can you be a little more expansive on the question please.
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
July 19, 2010 at 3:16 am
What you're saying in that trigger is once a row has been inserted, please insert a second row with blank values. INSERT always adds a new row.
If you want to...
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
July 19, 2010 at 3:14 am
Please post table definition and your current trigger.
My guess is that you're inserting within the trigger. That'll create a new row. What you rather need to do (assuming this 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
July 19, 2010 at 2:02 am
Sanjay-940444 (7/19/2010)
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
July 19, 2010 at 1:52 am
Sanjay-940444 (7/19/2010)
Whats better ?To perform whole task using many small and simple queries
or
to perform task using big, compact and probably complex queries.
It depends.
Seriously, there's no one single answer to 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
July 19, 2010 at 1:40 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic954585-65-1.aspx
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
July 18, 2010 at 11:56 pm
Source control?
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
July 18, 2010 at 11:52 pm
Two different connections try to create a table #test and both succeed and get different, independent tables.
Two different connections try to create a table test in TempDB, the first succeeds,...
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
July 18, 2010 at 11:52 pm
Steve Jones - Editor (7/18/2010)
Jack Corbett (7/18/2010)
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
July 18, 2010 at 11:44 pm
You're going to have to explain in more detail what tables you have, how they are partitioned, where the partitions are and how the file/filegroups are set up for us...
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
July 17, 2010 at 11:42 am
Those CTPs have expiry dates built into them. Even if you do manage to get in installed, it won't run. why don't you download the evaluation version of 2008 and...
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
July 17, 2010 at 9:37 am
Unlikely.
What you can do is make a copy of the DB (backup/restore) then delete the partitions and filegroups that you don't need from each 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
July 17, 2010 at 7:34 am
This related to your attempts to recover data from that 2005 database http://www.sqlservercentral.com/Forums/Topic953659-391-1.aspx?
If so, my advice on that thread stands. The only way you even have a chance to recover...
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
July 17, 2010 at 7:32 am
Viewing 15 posts - 31,756 through 31,770 (of 49,552 total)