Viewing 15 posts - 796 through 810 (of 5,394 total)
SQLRNNR (1/29/2015)
erm - too early in the morning. I meant to say alias and not hint.
No worries, it was clear enough 😉
January 29, 2015 at 9:13 am
SQLRNNR (1/29/2015)
Ed Wagner (1/29/2015)
spaghettidba (1/29/2015)
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
That what will soon be illegal in SQL? (You have an unclear antecedent for the second "that" in your edited comment.)
The omission of...
January 29, 2015 at 7:47 am
GilaMonster (1/29/2015)
Brandie Tarvin (1/29/2015)
That what will soon be illegal in SQL? (You have an unclear antecedent for the second "that" in your edited comment.)
The omission of the WITH on the...
January 29, 2015 at 6:38 am
Eirikur Eiriksson (1/29/2015)
Quick solution which excludes any columns with a character after the column prefix...
NOT LIKE CONCAT(@COL_PREFIX,N'%[A-Z,a-z]%');
I don't think this is enough to exclude symbols and other characters not...
January 29, 2015 at 4:14 am
ISNUMERIC returns surprising results and it is not the best way to check for a number.
Try this instead:
SELECT *
FROM (
VALUES('L1'),('L2'),('L100'),('Field1'),('Field2')
) AS v(name)
WHERE name LIKE 'L%' --...
January 29, 2015 at 4:01 am
You cannot. That's the whole point of TDE.
If ServerA is not available any more, I guess you're out of luck.
January 29, 2015 at 1:54 am
You cannot log in because the service is stopped.
It won't start because of the corruption error you found in the event viewer.
Go to the Log directory of SQL Server and...
January 28, 2015 at 4:10 am
rodjkidd (1/23/2015)
Gianluca - well introduce yourself at the registration desk. I'll probably be on it with the other helpers at some point...
Oh and nowhere near 2m tall! But probably armed...
January 26, 2015 at 4:37 am
If I understand correctly, what yoy want is two distinct IP addresses and 2 names in DNS for this machine.
Then you just have to tell each SQL Server instance to...
January 23, 2015 at 9:05 am
Probably the query plan has changed, due to increase in the number of rows.
Try to examine the execution plan for the query that appears to run forever and see if...
January 23, 2015 at 8:56 am
GilaMonster (1/23/2015)
Generally for backups you want the storage as simple as possible so that retrieving the files for a restore is as easy as it can be...
January 23, 2015 at 8:53 am
As you might expect, "it depends" is the most appropriate answer.
Keep in mind that bigger batches require more T-LOG space.
It also depends on how expensive is the query to find...
January 23, 2015 at 8:50 am
Glad I could help
January 23, 2015 at 6:55 am
GilaMonster (1/23/2015)
Luis Cazares (1/22/2015)
Brandie Tarvin (1/22/2015)
rodjkidd (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for...
January 23, 2015 at 2:17 am
Viewing 15 posts - 796 through 810 (of 5,394 total)