Viewing 15 posts - 42,256 through 42,270 (of 49,571 total)
Robert Frasca (12/19/2008)
I found heap, clustered, non-clustered, and XML as the only valid "types".
Heap, no. It doesn't have the b-tree structure, it's not an index.
Don't forget spatial indexes on...
December 19, 2008 at 8:32 am
Grant Fritchey (12/19/2008)
I want to try this on my own, but I'm a bit busy. Has anyone tried querying sys.dm_exec_query_plan?
Plans are there. Fairly easy to identify too, the objectid in...
December 19, 2008 at 8:28 am
Domagoj Orec (12/19/2008)
I wonder what happens with 50+ year olds in IT, how they cope with learning new things?
My colleague's around that age and he runs rings around me...
December 19, 2008 at 8:20 am
A hardcoded password is a bad idea, for this reason and others.
You can put the password in the app.config file (encrypted) and have it different on dev and prod. Preferably...
December 19, 2008 at 8:18 am
Please don't repost a question that people are working on. It just leads to redundant replies and means people will waste their time answering questions that have already been answered.
Please...
December 19, 2008 at 8:16 am
Your original question asked how to copy a database.
Do you need to copy an entire database or a single table within a database?
If the latter, is there a linked...
December 19, 2008 at 7:59 am
Peso (12/19/2008)
Not even with SQL Profiler?You can get every statement within the function there.
True, though that's a hellishly painful way to get execution plans.
I need to check and see if...
December 19, 2008 at 7:35 am
ddorfman (12/19/2008)
ThanksHow to i get the actual execution plan of running just a TVF
You don't. 🙁
Take the contents of the function, put in management studio, declare variables in place...
December 19, 2008 at 7:14 am
Perry Whittle (12/19/2008)
assuming it is released quick enough
Sure, but the chances of the OS coming under sudden , extreme memory pressure on a dedicated SQL server machine are slim, unless...
December 19, 2008 at 7:05 am
Backup the database
Copy the backup file to the other server
Restore the backup.
December 19, 2008 at 7:01 am
Russell.Taylor (12/19/2008)
December 19, 2008 at 7:00 am
Chris Morris (12/19/2008)
It's a longshot, but have you tried putting this little lot into a sproc and running the results into a prepared table?CREATE TABLE...
INSERT INTO ... EXEC ...
That's very...
December 19, 2008 at 6:59 am
Swirl80 (12/19/2008)
out of curiosity, from a performance point of view, which is better:
As I said above, they are identical in meaning and in effect.
Neither is desired for performance reasons. If...
December 19, 2008 at 6:52 am
Perry Whittle (12/19/2008)
just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt.
Lock pages just means that the...
December 19, 2008 at 6:52 am
When you create the job step, set the type to OS command. They type in the OS commands that you need.
December 19, 2008 at 3:23 am
Viewing 15 posts - 42,256 through 42,270 (of 49,571 total)