Viewing 15 posts - 31,366 through 31,380 (of 49,552 total)
When there's an identity column on the destination table. The order by will set the order of the identity. Nothing else.
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
August 9, 2010 at 6:45 am
email-935809 (8/9/2010)
freeing caches once a day.
Don't do that. You're just making SQL do more work
Do you think 4GB ram is enough? Windows 2003 32 Bit, can I enable 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
August 9, 2010 at 6:42 am
p.s. Users using the sa account is one of the worst possible security practices. Get the users their own logins with the minimum permissions they need to do their job.
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
August 9, 2010 at 5:35 am
Tell whoever made that decision that having 4 cals and 10 connections will get you some nasty fines when you get audited.
The blocking, however, is not related. What did 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
August 9, 2010 at 5:34 am
It won't cause blocking. Lack of licences will cause you some problems when you get audited.
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
August 9, 2010 at 5:12 am
No need, there's no deleted or answered settings here. If you want, you could post the solution for anyone who runs across the thread from a search engine.
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
August 9, 2010 at 5:05 am
karin.askeroth (8/9/2010)
I'm beginning to think I'm in the wrong forum, maybe this isn't a place for any questions concerning how to use sql?
Well it's the newbies forums, so I...
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
August 9, 2010 at 5:02 am
vamshikrishnaeee (8/9/2010)
1. Now which index is selected 'f' or 'c' ?
Depends which of fid and cid is more selective. There's no covering index here so it depends which one 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
August 9, 2010 at 4:59 am
Where are the values coming from? They're not SQL variables (no @). They look like column references, but there's no table in scope.
Take a couple steps back, give us 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
August 9, 2010 at 4:55 am
Why dynamic SQL?
That's not the entire batch? Please post the entire thing.
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
August 9, 2010 at 3:56 am
If you're running the trace via the profiler GUI on Machine A then anything that shuts Profiler down will stop the trace.
You should be aware that using the Profiler GUI...
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
August 9, 2010 at 3:25 am
The query is probably returning too many rows for the lookups to be considered a good option. If that query is returning more than about 1% of the table, 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
August 9, 2010 at 2:57 am
Sudeepta (8/9/2010)
A Transaction log backup contains all the changes made since last full/diff/t-log backup.
A transaction log backup contains all the changes made since the last transaction log backup. The only...
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
August 9, 2010 at 2:56 am
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
August 9, 2010 at 2:55 am
When you say you can't attach, did they give errors > If so what exactly was the error?
re the DAT and LOG files, the MDF and LDF extensions are 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
August 8, 2010 at 5:06 am
Viewing 15 posts - 31,366 through 31,380 (of 49,552 total)