Viewing 15 posts - 1,696 through 1,710 (of 2,462 total)
I just had an external Vendor call and mention they want to change the Fill Factor setting for a server.
In my experience it's better to leave the the server setting...
-- Itzik Ben-Gan 2001
March 23, 2015 at 3:21 pm
Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these indexes are...
-- Itzik Ben-Gan 2001
March 23, 2015 at 2:59 pm
Phil Parkin (5/3/2009)
Have a look here for an example of how it can be done.http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx
Blog is down :crying:
-- Itzik Ben-Gan 2001
March 23, 2015 at 1:48 pm
Forgive me if I'm wrong (it's been a while and I'm going by memory here). You can go to Start > Run (or Windows key + R in windows 8+)...
-- Itzik Ben-Gan 2001
March 20, 2015 at 1:55 pm
I think this should do the trick:
WITH t1 AS
(
SELECT * FROM #Test1
CROSS APPLY (VALUES ('Actual'),('Budget')) ab(RecType)
)
SELECT
RecType,
recID, MyDate,
CASE...
-- Itzik Ben-Gan 2001
March 20, 2015 at 10:26 am
1. The TIME datatype does not exist in 2005 (it was introduced it 2008)
2. Your query appears to have been cut off.
-- Itzik Ben-Gan 2001
March 20, 2015 at 10:06 am
It's also worth noting that sometimes a cursor performs much better than a loop (e.g. the WHILE logic that you are using).
That said, and has already been mentioned, you...
-- Itzik Ben-Gan 2001
March 20, 2015 at 10:02 am
DECLARE @i tinyint = 1;
WHILE @i <= 5
BEGIN
If exists (select fieldID from #tmploginfo where status <> 0
group by fieldID
having count(*) > 0)
begin
backup log rdb to disk = N'C:\rdb1.trn'
End;
SET...
-- Itzik Ben-Gan 2001
March 20, 2015 at 9:58 am
mattech06 (3/19/2015)
I seem to have an odd situation.
I have a view that when created holds about 40k of rows.
when I use
SELECT DISTINCT RefTypeWord FROM vw_Referrals where ClientRef = 'EPS' or...
-- Itzik Ben-Gan 2001
March 20, 2015 at 9:29 am
twin.devil (3/20/2015)
-- Itzik Ben-Gan 2001
March 20, 2015 at 9:03 am
Sorry, I completely misunderstood your requirement. I will look at this again later today.
-- Itzik Ben-Gan 2001
March 20, 2015 at 8:47 am
You're returning a Table Valued Function so you need to return a IEnumerable (Note: CLR Table-Valued Functions)
I have not written a CLR in a while but I think that
public...
-- Itzik Ben-Gan 2001
March 20, 2015 at 8:46 am
If by "remove log files" you want to delete the records in tempsysdatabase where the names are: rdb_log3 and rdb_log4
This should work:
DELETE FROM #tempsysdatabase
WHERE name IN
(
select #tempsysdatabase.name, count (#temploginfo.FieldId) as...
-- Itzik Ben-Gan 2001
March 19, 2015 at 4:45 pm
jbalbo (3/19/2015)
Thanks for getting back so quick.
I get most if it, just a bit confused on the dataset part.
Here is the dataset I am using, if you could incorporate...
-- Itzik Ben-Gan 2001
March 19, 2015 at 3:21 pm
I don't believe that you can disable/enable a parameter (I could be wrong but I am pretty sure that you can't).
One thing you can do is this:
You have a parameter...
-- Itzik Ben-Gan 2001
March 19, 2015 at 1:55 pm
Viewing 15 posts - 1,696 through 1,710 (of 2,462 total)