Alan Burstein

Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 2,458 total)

RE: Re-creating users after database restore

SQL Guy 1 (10/10/2012)
Here is my scenario: I backup a production database and restore it to dev environment. But after the database is restored, I don't want to have...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 10, 2012 at 3:09 pm

#1547824
RE: Query Help

yogi123 (10/10/2012)
Hello Everyone
I Have one task, in that there are two tables,
one has student testing dates
and other has student enrollment dates.
CREATE TABLE #TestDates
(
iSchoolYearCode int NOT NULL,
dtStartDate DATETIME NOT NULL
)
insert into...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 10, 2012 at 2:52 pm

#1547815
RE: Regular expression in T-sql

Jeff Moden (10/3/2012)
XMLSQLNinja (10/3/2012)
In the same article he does recommend, for example, using a CLR for regexs (he includes a couple in the article). He tests the regex CLR vs...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 8:45 pm

#1545306
RE: Regular expression in T-sql

p.s. thanks jeff for the link... I am still reading that (very long) thread. Great stuff.
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 4:23 pm

#1545261
RE: Regular expression in T-sql

bteraberry (10/3/2012)
The Dictionary.com definition of kludge:
a software or hardware configuration that, while inelegant, inefficient, clumsy, or patched together, succeeds in solving a specific problem or performing a particular task
I would...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 4:20 pm

#1545257
RE: Replication ISSUES

deebabat (10/3/2012)
Ok. We're getting somewhere.
Re: missing tables-You will need to create a subscription to the second publication to get those tables. Each subscription can only subscribe to one publication.
Re:...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 2:13 pm

#1545205
RE: Replication ISSUES

deebabat (10/3/2012)
I am getting the table from one publication but some of the tables are empty, I'M NOT getting any table from the second publication at all.
... one other...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 1:20 pm

#1545183
RE: Replication ISSUES

deebabat (10/3/2012)
I am getting the table from one publication but some of the tables are empty, I'M NOT getting any table from the second publication at all.
Ok. We're getting...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 1:18 pm

#1545179
RE: Replication ISSUES

deebabat (10/3/2012)
I have two publications but one subcription
Are you getting all the tables from one publication and not the other?
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 3, 2012 at 1:02 pm

#1545170
RE: Regular expression in T-sql

Eugene Elutin (10/1/2012)
A couple of us just went through all of this on another thread a couple of months ago and the LIKE expressions blew the doors off the RegEx...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

October 1, 2012 at 6:02 am

#1543934
RE: Regular expression in T-sql

Jeff Moden (9/28/2012)
XMLSQLNinja (9/28/2012)
bteraberry (9/28/2012)
Microsoft invested a huge amount of effort/time/money into CLR to give us tremendous capabilities. I have been told by someone close to the SQL dev...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

September 29, 2012 at 9:09 am

#1543697
RE: Regular expression in T-sql

Jeff Moden (9/28/2012)
XMLSQLNinja (9/27/2012)
CELKO (9/15/2012)
...And then there is a high cost of CLR. .
Hogwash. There is nothing "high cost" about a well written CLR.
Avoid this kludge if you...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

September 29, 2012 at 8:32 am

#1543691
RE: Regular expression in T-sql

bteraberry (9/28/2012)
Microsoft invested a huge amount of effort/time/money into CLR to give us tremendous capabilities. I have been told by someone close to the SQL dev team at MS...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

September 28, 2012 at 5:10 pm

#1543648
RE: Regular expression in T-sql

CELKO (9/15/2012)
...And then there is a high cost of CLR. .
Hogwash. There is nothing "high cost" about a well written CLR.
Avoid this kludge if you can.
There's nothing "kludgy"...
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

September 27, 2012 at 11:29 pm

#1543188
RE: Practical used of database id

Shadab Shah (9/6/2012)
Thank You
no problem. 😀
"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."
-- Itzik Ben-Gan 2001

September 6, 2012 at 10:26 pm

#1534836

Viewing 15 posts - 2,371 through 2,385 (of 2,458 total)