Viewing 15 posts - 44,731 through 44,745 (of 49,552 total)
If you can post the code, I'm sure someone will be able to help you remove the cursor.
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
September 2, 2008 at 2:07 am
Generally, yes, but you should test your queries to make sure they use the indexes you've created.
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
September 2, 2008 at 2:04 am
Use the fn_trace_getdata function to load the trace data into a SQL table. Then you can query the trace data to get your information.
The only metrics you can compare your...
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
September 2, 2008 at 2:03 am
If you're asking for all the values in the table to be read (as you are) the only way that SQL can possible do that is to scan the index....
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
September 2, 2008 at 2:00 am
Default database.
What you need to get out of the syslogins is the login name, the password (hashed) and the SID. The SID is what will link up the logins with...
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
September 2, 2008 at 1:43 am
Don't enable AWE with only 4 GB memory. Enable the /3GB switch in boot.ini.
As for the cumulative updates, run SELECT @@Version and compare the version number to the very comprehensive...
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
September 2, 2008 at 12:35 am
Jeff Moden (9/1/2008)
GilaMonster (9/1/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
September 2, 2008 at 12:19 am
It only works if you're connected to a SQL 2008 server. If you're connected to any lower version, intellisense is disabled
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
September 2, 2008 at 12:10 am
Try restoring the backup to another server as a normal user database, then scripting the logins from the syslogins table.
Please, in the future, put SQL 2000-related questions into the 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
September 1, 2008 at 11:58 pm
Dougo (9/1/2008)
Where would I find the logical scan fragmentation percentage?
It's called that in DBCC showcontig. If you're using sys.dm_db_index_physical_stats (which I assume you are) then the avg_fragmentation_in_percent is the logical...
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
September 1, 2008 at 11:56 pm
rbarryyoung (9/1/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
September 1, 2008 at 11:43 pm
rbarryyoung (9/1/2008)
Of course we use a startup procedure to define the UDT's in TempDB.
Does defining them in model work as well?
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
September 1, 2008 at 11:41 pm
It should, yes.
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
September 1, 2008 at 11:42 am
In sql 2005 and higher, Top 100% ... order by is only honoured if it is in the outermost select statement.
This will return in random order
SELECT * FROM (
...
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
September 1, 2008 at 5:58 am
thatok (9/1/2008)
I have a table IRchair which has columns staffno and clusterid. I am going to add to this table a clumn named period. So I need to bring...
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
September 1, 2008 at 5:44 am
Viewing 15 posts - 44,731 through 44,745 (of 49,552 total)