Viewing 15 posts - 45,316 through 45,330 (of 49,552 total)
Can I ask why you want the results ordered like this?
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 31, 2008 at 4:49 am
Is there anything other that SQL Server on that server?
I would suggest you run profiler for a while during the slow periods (or preferable a server-side trace) and look for...
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 31, 2008 at 4:36 am
Stats give the optimiser an idea of the distribution of data in a column or set of columns. In my opinion, it's not all that useful to create statistics, 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
July 31, 2008 at 4:32 am
shalu (7/31/2008)
s it possible to deattach the log file and attach it over there. This will save time.
No. If you want to detach, copy and attach it has 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 31, 2008 at 3:07 am
a648 (7/30/2008)
I was looking at getting The Guru's Guide to Transact SQL but it's from 2000 and probably a little out of date, as we're using SS 2005 🙂
All...
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 31, 2008 at 2:35 am
Boot from local drives, not from SAN. Is it a clustered implementation?
Leave the CPU affinity as is.
You will have to enable /pae and AWE with that much memory. Set 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
July 31, 2008 at 2:28 am
shahbaz_awan (7/31/2008)
SELECT * INTO #INS FROM INSERTEDit works fine.
I just want to run this query via EXEC command.
You can do it, but the scoping rules around Temp Tables means 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 31, 2008 at 2:23 am
To get the data in a specific order, you will have to specify an order by clause. There is no other way to guarantee an order.
Do you just 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 31, 2008 at 2:22 am
Could you explain a bit more what you're trying to achieve here 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 31, 2008 at 2:20 am
Maybe. 🙂
If you detach a db you can attach it (providing there's no corruption) If you shut the DB down cleanly, move the files and attach, you will probably be...
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 31, 2008 at 2:18 am
A quick guess - have you removed Builtin\Administrators from the allowed logins? If so, put it back, make it sysadmin and try the patch again.
No promises. That security patch breaks...
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 31, 2008 at 2:14 am
Any log backups that you take on a DB that's the source of logshipping must be shipped to the secondary machine and applied. If you don't, the log backups taken...
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 31, 2008 at 2:12 am
SQL 2000 has no built in forms of encryption. (well, not ones that are decryptable)
SQL 2008 has transparency database encryption which protects the DB files on disk and the backups,...
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 31, 2008 at 2:09 am
Run them all and see which is faster.
The 1st and 2nd should be identical. The explicit joins are preferred over the joins in the where clause for readability at 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
July 31, 2008 at 2:07 am
Fourth highest record by what? Please post the table definitions and some sample data. The same comment applies to the 2nd part of your question. Without more info I can't...
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 31, 2008 at 2:06 am
Viewing 15 posts - 45,316 through 45,330 (of 49,552 total)