Viewing 15 posts - 5,716 through 5,730 (of 7,608 total)
lawson2305 (10/9/2014)
Scott I wanted to add what does multiple data files provide? Is there a read on this somewhere?
Yes, plenty of people have investigated and written on this. ...
October 9, 2014 at 9:43 am
lawson2305 (10/8/2014)
October 8, 2014 at 1:10 pm
joepacelli (10/8/2014)
it's my identity column which is returning 0
I also tried Ident_current('dbo.jobid')
This returns the correct value
But, according to MSDN site
Be cautious about using IDENT_CURRENT...
October 8, 2014 at 1:03 pm
Luis Cazares (10/8/2014)
ScottPletcher (10/8/2014)
October 8, 2014 at 12:59 pm
Eirikur Eiriksson (10/3/2014)
datediff(day, convert(varchar,MANUFACTUREDDATE, 101),convert(varchar,getdate(), 103))
,it is comparing MM/DD/YYYY to DD/MM/YYYY, the only thing the convert does in the query is setting the format of the output...
October 8, 2014 at 11:29 am
@@ROWCOUNT must be captured immediately after the SQL statement or its value gets reset.
However, since you've added an OUTPUT clause, you can get the number of rows affected form that...
October 8, 2014 at 11:23 am
Hmm, seems to be that code would list the same customer, the "first" one, over and over rather than listing every individual customer in the state. Are you actually...
October 8, 2014 at 11:16 am
Hmm, I read it as going to varchar to nvarchar.
That is tricky, if any code uses local variables of type "varchar" to hold those columns. Given the implicit conversion...
October 7, 2014 at 3:50 pm
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
You're welcome!
Please let me know [if] it actually helps.
It's working just fine. Before creating the index on the table, deadlocks occurred every half an hour but...
October 7, 2014 at 2:57 pm
Luis Cazares (10/7/2014)
ScottPletcher (10/7/2014)
For consistency, I'd stick with just explicitly CASTing the second value to an int:
SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS int)
I agree with you, but you missed...
October 7, 2014 at 11:39 am
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
Now this is the...
October 7, 2014 at 11:37 am
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
Now this is the warning I am getting:
Warning!...
October 7, 2014 at 11:14 am
New Born DBA (10/7/2014)
ScottPletcher (10/7/2014)
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
Now this is the warning I am getting:
Warning! The maximum key length...
October 7, 2014 at 11:05 am
For consistency, I'd stick with just explicitly CASTing the second value to an int:
SELECT CAST(DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()), 0) AS int)
October 7, 2014 at 11:01 am
USE [DBName]
GO
CREATE CLUSTERED INDEX [Company_FormName] ON [dbo].[COLUMN_NEXT_ID]
(
[Company], [Form_Name]
)WITH ( FILLFACTOR = 100 ) ON [PRIMARY]
October 7, 2014 at 10:57 am
Viewing 15 posts - 5,716 through 5,730 (of 7,608 total)