Viewing 15 posts - 256 through 270 (of 470 total)
It'll vary from company to company and position to position but I recommend picking up a copy of Thomas LaRock's DBA Survivor. It'll have the info you're looking for.
July 22, 2011 at 11:17 am
Are there any errors in the error log that give a little more detail? Have you tried using execute as user instead? I doubt it'll work but it's...
July 22, 2011 at 11:11 am
It's trying to get you to create a covering index. Just because SQL reports an index as missing doesn't mean you need to create it. There is a...
July 22, 2011 at 11:03 am
nawillia (7/22/2011)
...(he's using this in dynamic sql so a regular temp table doesn't work)...
If you can create the temp table outside the dynamic SQL you can reference it inside. ...
July 22, 2011 at 10:53 am
Details on what the errors are would be good. Were there any issues during the upgrade?
July 22, 2011 at 10:02 am
We don't use policies to manage SQL yet. I'm planning on testing it out and see if it's something we want to pursue but don't have time to do...
July 22, 2011 at 7:58 am
Shark Energy (7/22/2011)
July 22, 2011 at 7:47 am
Execute as user is made up? It actually does exist but my guess was that it couldn't be used when executing policies.
BOL reference:
July 22, 2011 at 7:43 am
I have a good feel for how much I'm worth. I did some research before leaving my last job. Straight salary I'm probably a little low where I...
July 22, 2011 at 7:36 am
Ninja's_RGR'us (7/20/2011)
:w00t: thanx for the chuckle!
I think I've found your master plan. Keep our points low by putting a tricky question up while increasing your own by replying to...
July 20, 2011 at 2:12 pm
david.moule (7/20/2011)
Strangely when I run this code and do a select on the table I get 8 rows.(SQL Server 2000)
Code and execution plan would be good to see. I...
July 20, 2011 at 10:27 am
Trevor Tinsley (7/20/2011)
July 20, 2011 at 10:22 am
My first assumption was that the final union all was intentional and the test was that the union was being inserted into the same table that was being selected from....
July 20, 2011 at 9:52 am
To know for sure we'll need the execution plan of both queries but my bet is that somehow this line is causing a table scan:
...
July 19, 2011 at 2:47 pm
I'm guessing that this isn't as simple as the file exists already and SQL can't overwrite it or the folder name being named wrong.
I don't see a response to whether...
July 19, 2011 at 2:27 pm
Viewing 15 posts - 256 through 270 (of 470 total)