Viewing 15 posts - 796 through 810 (of 5,393 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 😉
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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%' --...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
January 28, 2015 at 4:10 am
I don't think it can be done.
-- Gianluca Sartori
January 27, 2015 at 6:40 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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
January 23, 2015 at 8:50 am
Glad I could help
-- Gianluca Sartori
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...
-- Gianluca Sartori
January 23, 2015 at 2:17 am
Viewing 15 posts - 796 through 810 (of 5,393 total)