Viewing 15 posts - 47,326 through 47,340 (of 49,552 total)
Typical management. Tell them straight, there is no 64 bit solution to this problem.
If you have SQL Server 2005, you can rewrite all the DTS packages in SSIS (not...
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
February 20, 2008 at 11:13 pm
Please don't cross post. It wastes people's time. Mos of us read all the forums.
Replies to the following thread plase - SSIS Expert
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
February 20, 2008 at 11:10 pm
As far as I know, there's no 64 bit compile of DTSRun.
I ran into exactly the same issue when we moved our app onto an Itanium. We had 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
February 20, 2008 at 1:41 pm
You're ordering by the string conversion of a date, not the date time itself. Therefore 10:24 PM comes before 6:45 AM. (because 1 comes before 6)
If datetimestamp is a datetime...
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
February 20, 2008 at 1:38 pm
Please don't cross post. It wastes people's time.
Replies to the following thread please - AWE Settings
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
February 20, 2008 at 1:29 pm
I don't know if there's a limitation,and I'm almost scared to ask why you're asking. In general, my opinion on triggers is as few as possible, executing as infrequently as...
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
February 20, 2008 at 12:55 pm
What edition of SQL? What OS? 64bit? 32 bit?
Do you have the /pae switch in the boot.ini file?
Did you restart the SQL instance after enabling AWE?
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
February 20, 2008 at 9:23 am
Jeremy (2/19/2008)
Temp Tables...
3. Are persisted in tempdb
So are table variables. Both will reside only in memory unless there is memory pressure, or the number of rows becomes too large 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
February 20, 2008 at 9:12 am
I wrote a short comparison of temp tables and table variables a while back. - Temp tables vs table variables[/url]
Might be of some use.
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
February 20, 2008 at 9:09 am
7 indexes shouldn't slow an insert down that much.
Can you post the code for that step, the table structure and the index definitions please? Also check to see if there...
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
February 20, 2008 at 9:07 am
This should do what you want.
The subquery gets the max date for each parent product. Then join the subquery back to the table on both columns to get the rest...
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
February 20, 2008 at 1:42 am
karthikeyan (2/20/2008)
I have attended an interview two weeks back. He asked me the mentioned question.
There's not enough context to know what he was asking about
Gila, are you from US or...
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
February 20, 2008 at 12:59 am
Local System is an account that has administrator rights on the local machine and NO rights to any other machine.
If you want SQL to be able to backup and restore...
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
February 19, 2008 at 10:38 pm
Maybe, depends on what the table looks like. What's your intention with that complex expression in the count?
Can you post the table's schema and the index definitions 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
February 19, 2008 at 5:48 am
Doing a reindex right after a defrag is redundant and a waste of time and server resources
A reindex does all that a defrag does and more.
You would typically use 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
February 19, 2008 at 2:59 am
Viewing 15 posts - 47,326 through 47,340 (of 49,552 total)