Viewing 15 posts - 451 through 465 (of 5,394 total)
SUBSTRING does what you desire.
SELECT SUBSTRING(LTRIM(RTRIM(REPLACE('Micro Soft','M','m'))), 2, LEN(LTRIM(RTRIM(REPLACE('Micro Soft','M','m')))) -2 )
June 5, 2015 at 3:20 am
rodjkidd (6/4/2015)
SQLRNNR (6/4/2015)
GilaMonster (6/4/2015)
Lynn Pettis (6/4/2015)
Alvin Ramard (6/4/2015)
Jeff Moden (6/4/2015)
Have any of you ever used a CTP of SQL Server to power your real production databases? ...
June 5, 2015 at 2:21 am
If this is a named instance, try disabling the firewall on your computer. Named instances rely on SQLBrowser, which uses UDP port 1434 to communicate. Some firewalls don't like the...
June 3, 2015 at 2:58 pm
Which column? From which table?
Please post table scripts, sample data end expected output.
See here for posting guidelines: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
June 3, 2015 at 7:57 am
June 3, 2015 at 7:55 am
Updatable subscriptions are deprecated.
Here's a writeup on the subject (which took me 10 seconds of Google to find): http://dinesql.blogspot.it/2011/03/sql-server-updatable-subscriptions-what.html
Is there anything in particular that you want to know?
June 3, 2015 at 6:46 am
Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1691082.aspx
June 3, 2015 at 5:01 am
Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1691077.aspx
June 3, 2015 at 4:58 am
Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1691077.aspx
June 3, 2015 at 4:58 am
Please post data in a consumable way.
Show us what you have tried.
See here for posting guidelines: http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
You're just a few clicks away from a good question!
June 3, 2015 at 4:55 am
You have many options to change the way dates are displayed in reporting services: just change the formatting options of the date field in the report.
As far as the sort...
June 3, 2015 at 3:15 am
Tempdb on C drive is really a bad idea.
C drive is best formatted with 4Kb allocation units, while database files are best stored on 64Kb formatted partitions.
As far as...
June 1, 2015 at 10:11 am
MotivateMan1394 (6/1/2015)
Which is best practice for me to use ssd ?mdf or ldf or temp db ?
Use it for whatever your system is hitting harder on random I/O.
Typically it can...
June 1, 2015 at 9:52 am
Viewing 15 posts - 451 through 465 (of 5,394 total)