Viewing 15 posts - 27,091 through 27,105 (of 39,793 total)
Not only that, the passphrase will need to be in code, or be entered by people. How many people can keep a shared passphrase secret?
If you think about it, not...
September 14, 2008 at 8:24 am
You can grant the CREATE PROCEDURE permission to a role and the developers could do that. They wouldn't be able to create necessarily under the owner of DBO, but you...
September 13, 2008 at 11:20 am
There are a variety of ways to do this (cursor, while), etc. Depends on what you need to do, but Sp_msforeachtable works.
September 13, 2008 at 11:20 am
Do you mean IP addresses?
If you are moving SANs, I'm not sure that it should matter for the IPs. I would suggest you attach the servers to the new SAN...
September 13, 2008 at 11:18 am
Your parenthesis don't match, You have an extra open one, and you need to either remove it or determine where you're missing the closing one.
September 12, 2008 at 11:34 am
The CTE is part of the statement. Duplicate the CTE in both statements.
September 12, 2008 at 11:18 am
You can disable CPUs with the affinity mask, but MS doesn't recognize that. The other solution (besides removing a CPU) is to run a VM and allocate only one CPU...
September 12, 2008 at 11:18 am
Those are good articles. Profiler will work if you can limit how the developers access (meaning trace their logins).
September 12, 2008 at 11:17 am
Not sure that's a correlation. If the page file is growing, I'd make it larger to start with. Restarting SQL Server can clear things out and it changes access patterns...
September 12, 2008 at 11:14 am
I've run integrity checks daily, as mentioned above, before backups. Alert someone if you find errors.
For rebuilds, I've moved to procedures that look for fragmentation and rebuild those ones only....
September 12, 2008 at 11:12 am
truncate is one of those strange ones. I'd go with David's suggestion of Execute AS if you must do this.
September 12, 2008 at 11:11 am
As an FYI, I got a Kindle two weeks ago and have been blogging a bit on it. The latest is here, a two week review:http://blogs.sqlservercentral.com/steve_jones/archive/2008/09/12/kindle-the-two-week-followup.aspx
September 12, 2008 at 10:04 am
It's been awhile, so someone with more recent experience might need to explain this, but
a share is supposed to be a common copy. I think we used shares to...
September 12, 2008 at 9:41 am
I never rejoined code, as an FYI. Stuff branched for a particular release and then remained there. Change were always on the main branch.
That fit that particular development cycle, but...
September 12, 2008 at 8:52 am
Viewing 15 posts - 27,091 through 27,105 (of 39,793 total)