SQL Server consolidation strategies and best practices
Learn about the benefits of SQL Server 2008 consolidation on Windows 2008, with details on the different consolidation strategies available to organizations.
2009-04-07
2,707 reads
Consolidation
SQL Server consolidation: Why it's an optimization
SQL Server consolidation benefits are high availability and lower licensing costs. Here's what to expect for hardware needs, system monitoring and SQL licensing.
2008-10-16
2,737 reads
How to generate SQL DML
I have this peculiar request. We have a library which all developers use to connect to the Production databases. During the course of their interaction with the DB, any Update or Delete statement requires me to take the current state of the Row(s) based on the where clause from the Update/Delete statement and generate all […]
2004-12-07
1 reads
RE: DatePart Function
To get the date, try using the following:Cast(Left(@Date,11) as Datetime)Replace @Date with your date variable.
2004-03-30
RE: setting parameters in steps
Try wrapping your query in your Execute SQL Task in a stored procedure and then pass in the parameter...this should work fine using the EXEC usp_mysproc ? syntax... hth, Michael Michael Weiss
2003-07-07
1 reads
2003-07-05
RE: Linked Servers and Connections
You didn't happen to mention all of the impact in the procedures from db1 to db2. We had very slow response accessing a second machine using the machine.database.dbo.table method - especially updating or performing transactions. For us, the answer was to always access the second machine through stored procedures and performance immediately became excellent. Guarddata-
2003-07-03
RE: Linked Servers and Connections
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-03
RE: db library dead !!!!
What datatype is the column "plant_per"? That would be the first thing I'd look at with a 6.5 to 2000 conversion. Look at BOL for an example of problems like this, keyword "decimal data type, compatibility issues":
2003-07-01
RE: Database can't be reached by users
Here's more information: I have a job set up that backs up this database. It's set to run as DBO. It fails. I run it under QA as me and it succeeds. I change the job to set it to run as me and it works fine. How do I get DBO to work on […]
2003-06-26
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers