Viewing 15 posts - 211 through 225 (of 717 total)
Makes me wish that SQL Server had the TRUNC function like Oracle, it is very handy for this purpose.
Someone even suggested it in Connect, http://connect.microsoft.com/SQLServer/feedback/details/483913/add-a-dateround-function-similar-to-oracles-trunc-for-date-handling, but it was turned down....
March 18, 2011 at 10:12 pm
If you go into SSMS and follow these steps you can see all the temp tables along with the number of rows and the size:
* Expand Databases
* Expand System Databases
*...
March 18, 2011 at 9:59 pm
John Hanrahan (3/18/2011)
create table #Money
(ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Date DATETIME
AMOUNT INT,)
SET IDENTITY_INSERT #Money ON
INSERT INTO #Money(ID, Date, Amount)
SELECT '1', ' 2/10/2010...
March 18, 2011 at 3:43 pm
Thanks for the question, it is good to get an idea of what Visual Studio is capable of.
March 18, 2011 at 10:10 am
Thanks for the question, it is interesting to know that you can have a superfluous comma in a CREATE TABLE statement. (Not sure that is of much value other than...
March 18, 2011 at 10:06 am
ben-564110 (3/17/2011)
The question could be slightly more specific. Backup compression existed before SQL Server 2008 R2 Standard Edition was released (it existed in SQL Server 2008 Enterprise).
Really? More specific than...
March 17, 2011 at 1:52 pm
Kudikai (3/17/2011)
UMG Developer (3/16/2011)
You could go with VMs to limit memory but that really messes with the licensing.
I really should have specified that our entire environment is virtual, and the...
March 17, 2011 at 10:01 am
Since there are no other users during the delete try removing the row lock hint, you might even put a table lock hint. (Less work if it doesn't have to...
March 16, 2011 at 10:49 pm
It would help to know the table and index structures.
Some important things to know/help:
* How long is "FOREVER"?
* Is the table a heap or does it have a clustered...
March 16, 2011 at 10:22 pm
Another thing to think about is that unlike older 1 and 2 CPU servers that are SMP, Symmetric Multi Processing, which shares all memory across all CPUs, almost all current...
March 16, 2011 at 9:35 pm
I haven't seen that error on either of mine, but it sounds like something happened to your MDW database. Have you tried re-configuring it on the server hosting the MDW...
March 16, 2011 at 7:49 pm
Kudikai (3/16/2011)
I've been given permission to replace all three servers with a single new server.Win2k8R2, x64, 4CPU, 16GB Memory
Memory allocation ideally would be 8GB SQL, 4GB SSAS, rest to OS/SSRS/SSIS.
Overall...
March 16, 2011 at 7:41 pm
mtillman-921105 (3/16/2011)
March 16, 2011 at 4:52 pm
Vrosenberg (8/7/2010)
select distinct 'ALTER TABLE .[dbo].['+rtrim(P.name) +'] CHECK CONSTRAINT all'from [INFORMATION_SCHEMA].[CHECK_CONSTRAINTS] C
join sys.sysobjects O on name=CONSTRAINT_NAME
join sys.sysobjects P on P.id=O.parent_obj
You really should have the WITH...
March 16, 2011 at 10:05 am
Viewing 15 posts - 211 through 225 (of 717 total)