Viewing 15 posts - 45,331 through 45,345 (of 49,571 total)
Temp tables are dropped when the connection closes or when the stored procedure that created them ends. You can create global tables, but that's a little messy and if more...
July 31, 2008 at 10:02 am
Not enough information. Please post your table structure and give us an idea what the data looks like and what you want returned.
July 31, 2008 at 9:57 am
rbarryyoung (7/31/2008)
(actually, I cannot rememebr if you can use the mirror for reporting or not).
You can, using database snapshots. The mirror DB itself is not usable (recovering).
July 31, 2008 at 9:52 am
kokila (7/31/2008)
We are not having plan to implement Cluster.we can afford only 15 mins downtime.
A 15 minute downtime limitation and no cluster? What do you plan to do if the...
July 31, 2008 at 9:52 am
Can I ask why you want the results ordered like this?
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...
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...
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...
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...
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...
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...
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...
July 31, 2008 at 2:22 am
Could you explain a bit more what you're trying to achieve here please?
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...
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...
July 31, 2008 at 2:14 am
Viewing 15 posts - 45,331 through 45,345 (of 49,571 total)