Viewing 15 posts - 9,826 through 9,840 (of 49,571 total)
ChrisM@home (3/4/2014)
Less rows per page because of data duplication doesn't come without cost.
What data duplication?
There's always some overhead and someone always has to do the sums, calculate the cost-benefit.
Not in...
March 4, 2014 at 11:59 pm
ChrisM@home (3/4/2014)
1. How often do you change a clustered index on a production db?
I do fairly often, but then that's what I do mostly (database tuning on various badly performing...
March 4, 2014 at 11:36 am
ChrisM@Work (2/28/2014)
March 4, 2014 at 10:27 am
If it's a SQL login you have to make sure that the SID for the login is the same on both servers, otherwise the database user won't reference the login...
March 4, 2014 at 10:12 am
sqlbuddy123 (3/4/2014)
Use this query ..
SELECT [log_reuse_wait_desc]FROM [master].[sys].[databases]
--WHERE [name] = N'DB_Name';
That's just going to give a list of all the log reuse for...
March 4, 2014 at 10:09 am
IF EXISTS (SELECT 1 FROM sys.procedures WHERE name = 'ep_change')
PRINT 'Procedure exists'
March 4, 2014 at 6:44 am
psamyn (3/4/2014)
Strange, why does ssms then suggest this line when you apply this on a lig file when you choose for the option shrink file.
Because SSMS is a poorly written...
March 4, 2014 at 6:40 am
To be honest, no.
The kind of trigger you want isn't really an option. By the time a trigger which can tell the rowcount fires (like the one above), the data...
March 4, 2014 at 6:26 am
Then there's something going on that you're not telling us about, because there are no floats around in case statements I wrote for you and if the columns are CHAR(8),...
March 4, 2014 at 5:37 am
psamyn (3/4/2014)
This should do it also.DBCC SHRINKFILE (N'<DATABASE_LOG_FILE_NAME>' , 0, TRUNCATEONLY)
TruncateOnly has no meaning when applied to a log file shrink, it's an option for data files, and shrinking the...
March 4, 2014 at 5:18 am
Try this (a bit simplified and cleaned up)
SELECT DISTINCT
c.iCustomer_id ,
c.sCustomer_number AS CustomerNo ,
...
March 4, 2014 at 5:16 am
Disable the login or shut down the web app.
March 4, 2014 at 5:01 am
If you comment out the CASE in both the select and the where does the error go away?
March 4, 2014 at 5:00 am
Sushil Dwivedi (3/3/2014)
Will it help
Slightly. It'll tell you what procedures have been run since the last server restart and still have their plans in cache. It can't tell you that...
March 3, 2014 at 11:34 pm
Viewing 15 posts - 9,826 through 9,840 (of 49,571 total)