Viewing 15 posts - 1,576 through 1,590 (of 15,381 total)
monilps (4/27/2016)
SELECT 'EXEC sp_rename @objname = N''PK_Filegroup_Tables_ID'', @newname = N''PK_FilegroupTables_ID'';' as Script
SELECT 'Admin', 'PrimaryKey', 'FilegroupIndexes', 'EXEC sp_rename @objname = N''PK_Filegroup_Indexes_ID'', @newname = N''PK_FilegroupIndexes_ID'';' as Script
I would like to extract the...
April 27, 2016 at 10:44 am
JoNTSQLSrv (4/27/2016)
Hope all are doing good.
I have to design table for one small web project, which contains 4 screens. In my old company i was...
April 27, 2016 at 7:13 am
Lynn Pettis (4/26/2016)
Sean Lange (4/26/2016)
Alvin Ramard (4/26/2016)
Ed Wagner (4/26/2016)
Luis Cazares (4/26/2016)
Wonder if I should answer: "Using INSERT statements"http://www.sqlservercentral.com/Forums/Topic1781117-1550-1.aspx
Well, you would be correct. Tell them to create the table first....
April 26, 2016 at 1:53 pm
Alvin Ramard (4/26/2016)
Ed Wagner (4/26/2016)
Luis Cazares (4/26/2016)
Wonder if I should answer: "Using INSERT statements"http://www.sqlservercentral.com/Forums/Topic1781117-1550-1.aspx
Well, you would be correct. Tell them to create the table first. 😉
Tempted to reply with:...
April 26, 2016 at 1:17 pm
Michael L John (4/25/2016)
April 25, 2016 at 8:52 am
Hugo Kornelis (4/25/2016)
Sean Lange (4/25/2016)
Grant Fritchey (4/25/2016)
I've always liked "dumber than a bag of hammers"My favorite is "Sharp as a marble".
I like that one!
The Dutch version translates as "when God...
April 25, 2016 at 8:51 am
I don't see any huge issues with the query posted. However, the execution plan is way more complex than I was expecting. Then I re-read your post and one of...
April 25, 2016 at 7:10 am
Grant Fritchey (4/25/2016)
I've always liked "dumber than a bag of hammers"
My favorite is "Sharp as a marble".
April 25, 2016 at 7:00 am
Phil Parkin (4/22/2016)
Eirikur Eiriksson (4/22/2016)
Phil Parkin (4/22/2016)
Must. Resist.Couldn't resist
😎
Yikes. That thread is already following a familiar pattern.
I expect two more pages of fumbling, followed by: "It's OK. This problem is...
April 22, 2016 at 1:38 pm
mbavabohrude (4/22/2016)
Thanks for your infor . I will post the execution plan when i get the permission .Along with it i will update the table details .
Make sure you include...
April 22, 2016 at 8:43 am
Smendle (4/22/2016)
GilaMonster (4/15/2016)
EamonSQL (4/14/2016)
For example, if select @@trancount returns 4 can I find...
April 22, 2016 at 7:53 am
mbavabohrude (4/22/2016)
For the proc logic i have created a query based on the earlier input but the query run for 2.48 mins .1.How can i optimize this query .
We can't...
April 22, 2016 at 7:42 am
Michael L John (4/21/2016)
Michael L John (4/21/2016)
SQLRNNR (4/21/2016)
JustMarie (4/21/2016)
Brandie Tarvin (4/21/2016)
Eirikur Eiriksson (4/21/2016)
Brandie Tarvin (4/21/2016)
Luis Cazares (4/21/2016)
BLOB_EATER (4/21/2016)
Luis Cazares (4/21/2016)
Brandie Tarvin (4/21/2016)
April 21, 2016 at 10:46 am
mbavabohrude (4/21/2016)
Thanks for your response . It should be single query and not procedure .When i ran the query for one record i am getting below error ...
April 21, 2016 at 7:16 am
Steve Jones - SSC Editor (4/18/2016)
No more snow here, at least not forecast. It's cloudy, and foggy. Never know. I think weather forecasters are flipping coins half the time.
Just to...
April 18, 2016 at 9:13 am
Viewing 15 posts - 1,576 through 1,590 (of 15,381 total)