You know as well as all of us that requirements do change (par definition), are you...

This is simply a brute force division, could be done this way

😎

DECLARE @DECIM DECIMAL(18,5) = 125521.12345;

/* Brute force division */

;WITH NX(N) AS (SELECT N FROM (VALUES

(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS X(N))

,NUMBERS(N)...

Chowdary's (4/29/2014)

---

Dear All,

I know this is some what get irritate to you,Very sorry for that but i hope that you can give me some suggestions for This.

Am using Windows Server...

What about Base36, almost...

Sean Lange (4/29/2014)

---

What I don't really understand here is what is the point of this? This data is pretty much unusable because you have no way of putting it back...

Sean is quicker typing 😀

DECLARE @STRINGS TABLE

(

MYID INT IDENTITY(1,1) NOT NULL

,MYSTRING CHAR(4) NOT NULL

)

INSERT INTO @STRINGS (MYSTRING)

SELECT MYSTRING FROM

(VALUES...

Quick solution, you will have to sum up each row though

😎

USE AdventureWorks2012;

GO

DECLARE @TABLE_NAMESYSNAME= N'SalesOrderDetail';

DECLARE @TABLE_SCHEMASYSNAME= N'Sales';

DECLARE @SQL_STRNVARCHAR(MAX)= N''

SELECT

@SQL_STR = N'SELECT '+

STUFF((SELECT ',DATALENGTH(' + C.COLUMN_NAME + N') AS [DL_' +...

Set MIN and MAX memory to the desired number

😎

EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE

GO

EXEC sys.sp_configure N'min server memory (MB)', N'4096000'

GO

EXEC sys.sp_configure N'max server memory (MB)', N'4096000'

GO

RECONFIGURE...

If you open the package (dtsx) file in a text editor, does the XML look OK?

😎

I do have plans for implementation but still kind of struggling how to fit this into the architecture. There are certain benefits but the question is more how to fit...

I'll dig into it and let you know. Certain I have something and probably there are others that have similar, lets hope they share:-P

😎

SQLCurious (4/28/2014)

---

Thanks for all your inputs and suggestions. I will work towards implementing this in SSIS which seems to have better control. I appreciate everyone's time and effort in providing...

Take a look at Industry-specific Data Models from Database Answers[/url]

😎

When was the last restart? Have all procs executed since then?

😎

Please don't cross-post!