Viewing 15 posts - 1,471 through 1,485 (of 2,462 total)
Ditto everything Jason said. Some DDL and an example of what you are doing/trying to do would help.
Perhaps you can use this code as an example of how to...
-- Itzik Ben-Gan 2001
May 20, 2015 at 3:40 pm
20 GB seems rather large for a table with 4000 rows even with the max data types, and especially since your clustered index and 1-column non clustered index is taking...
-- Itzik Ben-Gan 2001
May 20, 2015 at 11:10 am
TJT (5/19/2015)
Sorry, I should have provided more information. The IP Addresses could be any IP addresses.I was trying to use REPLACE with RIGHT statement
Ok, by "any IP address" what...
-- Itzik Ben-Gan 2001
May 19, 2015 at 2:37 pm
Luis Cazares (5/19/2015)
Alan.B (5/19/2015)
You could do this:
DECLARE @ipaddresses TABLE (ip varchar(30));
INSERT @ipaddresses VALUES
('175.139.45.127'),
('175.139.45.12'),
('175.139.45.1'),
('10.10.10.100'),
('10.10.10.10'),
('10.10.10.1');
SELECT ip = PARSENAME(ip,1)+'.'+PARSENAME(ip,2)+'.'+PARSENAME(ip,3)+'.0'
FROM @ipaddresses
Alan, that's cheating. You didn't test your code. 😛
I guess I didn't :blush:
-- Itzik Ben-Gan 2001
May 19, 2015 at 2:32 pm
You could do this:
DECLARE @ipaddresses TABLE (ip varchar(30));
INSERT @ipaddresses VALUES
('175.139.45.127'),
('175.139.45.12'),
('175.139.45.1'),
('10.10.10.100'),
('10.10.10.10'),
('10.10.10.1');
SELECT ip = PARSENAME(ip,1)+'.'+PARSENAME(ip,2)+'.'+PARSENAME(ip,3)+'.0'
FROM @ipaddresses
-- Itzik Ben-Gan 2001
May 19, 2015 at 2:05 pm
Always this:
I want to find out if this is a good idea or I should design a transactional database for the application and a Data warehouse separate for the...
-- Itzik Ben-Gan 2001
May 19, 2015 at 1:17 pm
Angel DBA Mex (5/19/2015)
but already I´ve found the mistake, it is when the information has imported from a txt file, this has a special character, Char(13), Char(10),...
-- Itzik Ben-Gan 2001
May 19, 2015 at 12:51 pm
Or something like
ON
(Project_Code = Manager.Code AND Project_Code <> '')
OR
(Project_Code = '' AND Project_cost_center = Manager.Code)
-- Itzik Ben-Gan 2001
May 19, 2015 at 5:05 am
Avoid ad-hoc sql and use stored procs to drive your ssrs data. Faster queries mean faster reports; tune your queries - make em fast.
For your slowest reports consider...
-- Itzik Ben-Gan 2001
May 19, 2015 at 4:54 am
Jason A. Long (5/18/2015)
Alan.B (5/18/2015)
If the collation that the table is stored in is Case Insensitive then...
-- Itzik Ben-Gan 2001
May 18, 2015 at 9:48 pm
In Ben-Gan's T-SQL Fundamentals 2012 (Ch. 6) he dedicates a whole chapter to set operators. I would encourage anyone to trying to get a grasp on this topic to...
-- Itzik Ben-Gan 2001
May 18, 2015 at 9:09 pm
Use the parameters to create the URL like you specified and a message or something on how to create a bookmark, favorite, whatever using that string (that's just me thinking...
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:59 pm
Note the article in my signature about how to best get help here. Sample data and some DDL would really help. That said...
This wont be too hard: the solution will...
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:41 pm
I'm not 100% sure about this and hope someone corrects me if I'm wrong...
If the collation that the table is stored in is Case Insensitive then you use a Case...
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:29 pm
Make org_id an int.
declare @invoice table (inv_id int,inv_amt money,org_id int /*numeric(10,0)*/)
-- Itzik Ben-Gan 2001
May 18, 2015 at 8:41 am
Viewing 15 posts - 1,471 through 1,485 (of 2,462 total)