Viewing 15 posts - 16 through 30 (of 112 total)
WHERE FirstName like '%@FirstName%'
should be
WHERE FirstName like '%' + @FirstName + '%'
July 24, 2012 at 12:33 pm
GilaMonster (7/24/2012)
Daxesh Patel (7/24/2012)
Looks like the login account does not have enough permissions (probably "inserts into some table" in trigger).Where do you see a permissions related error?
You are right, this...
July 24, 2012 at 12:24 pm
Satya_0000 (7/23/2012)
DB ErrorTimeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
When I checked SQL...
July 24, 2012 at 11:32 am
I cannot write sql based on your input, but doing some study of ROW_NUMBER PARTITION BY will help
July 24, 2012 at 9:58 am
tim.cloud (7/23/2012)
36,000,000 is from the MAX server memory SQL setting.Yes, the OS is using the other 4MB.
But shouldn't there be some free room?
Max server memory, value is in MB
So 36,000,000...
July 23, 2012 at 12:27 pm
MAX is supposed to be 36,000,000
Where this come from? Have you set this value in Max server memory?
July 23, 2012 at 12:07 pm
Djcarpen11 (7/23/2012)
Well spotted, sorry it's my mistake it should be COLA =1.Can't figure out why it would as a literal value but not as a parameter.
Dave
What is data...
July 23, 2012 at 11:13 am
Sean Lange (7/22/2012)
lokeshvij (7/22/2012)
Another tip:Select your table in MSMS and then press Ctrl+F1
Check the result set with FK'S 😉
That is a super easy way to find foreign keys defined on...
July 23, 2012 at 9:52 am
Alter table <TableName>
Add Reporting_Date datetime not null default(dateadd(month,datediff(month,0,GETDATE()),0))
July 20, 2012 at 11:56 am
nishantshende-532951 (7/20/2012)
I have verified the Service Pack and other configuration and all are same.Nishant Shende
When you say "other configuration" what are those?
Execution plans are same in both the server?
July 20, 2012 at 11:21 am
vinu512 (7/20/2012)
July 20, 2012 at 6:31 am
Lowell (7/19/2012)
Daxesh Patel (7/19/2012)[hr
Hi Lowell,
I have a question, did you restore existing database (replaced existing from backup) in your test or created new database from backup?
Just curious
Thanks in advance
i tested...
July 19, 2012 at 10:20 am
Lowell (7/19/2012)
July 19, 2012 at 9:24 am
Hi,
Can you please let me know the option available to restrict the SQL Stored Proc , not to create a new execution plan every time it is executed and compiled..?...
July 17, 2012 at 11:43 am
Ok, instead of "restart" I "stopped" and then "started" sql service
and now I am not able to connect from my local machine.
Not sure about diffrence between "restart" and "Stop +...
July 17, 2012 at 9:02 am
Viewing 15 posts - 16 through 30 (of 112 total)