Viewing 15 posts - 4,441 through 4,455 (of 11,678 total)
pawan.khandelwal (10/18/2013)
ok..can you just give me rough estimate how much time SQL to take to fetch 20 million records
How can someone give an estimate on this?
It depends on too many...
October 18, 2013 at 5:46 am
401,415,793 is about 400 million. It's not even close to 40 billion.
Anyway, why would you want to select that amount of rows in SSMS?
October 18, 2013 at 5:07 am
Are you executing that directly in SSMS?
It's 40 billion (you sure it's not million?) rows, did you expect it to go fast?
If it's in SSMS, return data as text instead...
October 18, 2013 at 4:57 am
TWH (10/16/2013)
I've had a chance to dabble with a lot of aspects of SQL Server (even some PL/SQL).
PL/SQL is Oracle 😉
TWH (10/16/2013)
How do you keep current with SQL Server?
Mostly by...
October 18, 2013 at 4:55 am
You would do this with SSIS. Behind the scenes, the import wizard uses SSIS. In the last step you can choose to immediately run the package or to save it....
October 18, 2013 at 4:45 am
CREATE PROC dbo.myProc
@ReportingViews varchar(50)
@User varchar(50)
AS
SET @ReportingViews = CASEWHEN EXISTS
(
SELECT 1
FROM USER_PRFL up
INNER JOIN BSP_LOB_Grp_Lookup bl ON bl.BSP_LOB_GRP = up.User_Group
INNER JOIN IMPACTED_LOB il ON il.BSP_LOB_CD = bl.BSP_LOB_CD
WHERE BSP_LOB_GRP =...
October 18, 2013 at 3:44 am
wolfkillj (10/18/2013)
Well, I done gone and did it - now blogging (finally) at SQLSouth[/url] and tweeting from @SQLSouth. Hope you'll check 'em out!Having a blast at PASS Summit 2013!
Jason
Following you...
October 18, 2013 at 3:34 am
John Mitchell-245523 (10/18/2013)
October 18, 2013 at 3:14 am
SQL006 (10/18/2013)
John Mitchell-245523 (10/18/2013)
OK, then it's nothing to do with permissions. You won't be able to see the procedure definition unless you have the source code.John
thanks for the clarification.
Is...
October 18, 2013 at 3:13 am
John Mitchell-245523 (10/18/2013)
OK, then it's nothing to do with permissions. You won't be able to see the procedure definition unless you have the source code.John
Indeed. There's a big difference...
October 18, 2013 at 3:05 am
At my next event - the Belgian SQL Server Days - I will meet other speakers I've never met before, such as Thomas Larock, Karen Lopez, Mark G Stacey, Alex...
October 18, 2013 at 2:31 am
I haven't used SQL Server 2000 a lot, so I don't know if this is possible:
October 18, 2013 at 1:50 am
DECLARE @myRow VARCHAR(10) = 'ADC. DCD.';
SELECT ISNULL(REVERSE(STUFF(REVERSE(@myRow),CHARINDEX('.',REVERSE(@myRow),1),1,'')),@myRow);
ps: please read the first link in my signature on how to post questions (table DDL, sample data, desired output). It will help you...
October 18, 2013 at 1:44 am
Viewing 15 posts - 4,441 through 4,455 (of 11,678 total)