Viewing 15 posts - 4,156 through 4,170 (of 7,168 total)
Lynn Pettis (5/8/2012)
I would say it depends on the size of the databases and the amount of activity on each database.
As to...
May 8, 2012 at 9:54 am
Safe to assume 64-bit? How many CPUs assigned to SQL Server? How much RAM?
Worker Thread Recommendations for SQL 2012. I couldn't find any guidance on SQL 2008 R2, but you...
May 8, 2012 at 9:27 am
Jeff Moden (5/8/2012)
opc.three (5/8/2012)
jasonmorris (5/8/2012)
Where I work they always insist that any import tables for third party text data are nvarchar(4000)...
May 8, 2012 at 9:07 am
jasonmorris (5/8/2012)
Where I work they always insist that any import tables for third party text data are nvarchar(4000) and there is...
May 8, 2012 at 8:59 am
Try left joining from a Tally table to your data on export to fill the gaps.
Here is a derived Tally table you could use:
-- From: http://www.sqlservercentral.com/articles/Tally+Table/72993/
WITH E1(N) AS (
...
May 8, 2012 at 8:35 am
lil_emery13 (5/7/2012)
I am using MySQL through phpMyAdmin. Sorry for not clarifying.
No problem. This website is devoted to Microsoft SQL Server. While current versions of MySQL support User-defined Functions the SQL...
May 7, 2012 at 4:44 pm
Do they need access to other databases or resources on the instance? If the answer is no just disable their logins.
If the answer is yes then it gets a bit...
May 7, 2012 at 2:55 pm
My test started with an empty table.
IF EXISTS ( SELECT *
FROM sys.objects
...
May 7, 2012 at 2:45 pm
I have never seen such a thing in the wild...I was wondering if inserts might even be blocked so ran a quick test...they work. I also ran an execution plan...
May 7, 2012 at 2:00 pm
Nice! Happy to assist...I bet that felt good 😉
May 7, 2012 at 1:43 pm
polkadot (5/6/2012)
May 7, 2012 at 1:32 pm
If you spell it incorrectly the CREATE LOGIN command will let you know via refusing to create a login off a non-existent AD group. Sorry, I can't help with the...
May 7, 2012 at 1:13 pm
It also looks like you're trying to turn your SQL Server into an application server. What are you attempting to accomplish that you need to start a service on a...
May 7, 2012 at 1:09 pm
lil_emery13 (5/5/2012)
Thanks for your help, will look into create function.
Can you please confirm you're platform is SQL Server, and that the version you'll be developing for is SQL Server 2008?
I...
May 7, 2012 at 1:07 pm
Viewing 15 posts - 4,156 through 4,170 (of 7,168 total)