Viewing 15 posts - 6,691 through 6,705 (of 49,571 total)
Doctor Who 2 (1/26/2015)
I'm still not sure what sort of data type the @words variable is, though.
It'll be varchar or nvarchar
And another question. I've written UDF's before, but they were...
January 26, 2015 at 7:47 am
Sean Lange (1/26/2015)
Jack Corbett (1/26/2015)
Sean Lange (1/23/2015)
January 26, 2015 at 7:12 am
Probably both VARCHAR(8000) or VARCHAR(Max). There's no 'array' data type in SQL, there's no data type which enforces a particular combination of string contents.
January 26, 2015 at 6:56 am
Phil Parkin (1/26/2015)
sm_iransoftware (1/26/2015)
Then what is the best way to get Unused indexes?
And the last sentence of that article is really, really important.
January 26, 2015 at 6:30 am
Yes.
Before you do so, test and ensure that the index is useful and makes an appreciable improvement in the performance of the queries that it's intended to help.
January 26, 2015 at 6:29 am
Gazareth (1/26/2015)
Brandie Tarvin (1/26/2015)
GilaMonster (1/26/2015)
Steve Jones - SSC Editor (1/23/2015)
Sioban Krzywicki (1/23/2015)
GilaMonster (1/23/2015)
January 26, 2015 at 6:24 am
ChrisM@Work (1/26/2015)
Grant Fritchey (1/26/2015)
ChrisM@Work (1/26/2015)
Your wish etc etc PM me if you're sure and we'll fix it up.
Thanks! But I've already spent the money to build the other costume. Might...
January 26, 2015 at 6:23 am
No way to answer that. Maybe none of them. All of them are getting used, so unless you're very, very, very certain that there will be no performance degradation as...
January 26, 2015 at 4:56 am
Raymond van Laake (1/26/2015)
Then I dropped the login with:
CREATE LOGIN [test-login]
Err... CREATE LOGIN doesn't drop logins. Mis-paste?
Question: is it okay to delete the record in the sys.serverprinciples table? Or what...
January 26, 2015 at 4:33 am
Grant Fritchey (1/26/2015)
Well crap. Now I want to go as the Arrow. And I want the 135lb yew with some scary arrows please.
I think you'd make a very good Arrow....
January 26, 2015 at 2:14 am
Sean Lange (1/23/2015)
January 26, 2015 at 2:12 am
Steve Jones - SSC Editor (1/23/2015)
Sioban Krzywicki (1/23/2015)
GilaMonster (1/23/2015)
January 26, 2015 at 2:11 am
Make sure, when you create the login on the mirror, you specify the SID in the CREATE statement, otherwise it won't match the database user.
January 26, 2015 at 1:44 am
Don't use the Edit rows window. It's a little twitchy on a good day 🙂
If you put the trigger back as it was and use an update statement to change...
January 26, 2015 at 1:38 am
amy26 (1/23/2015)
January 26, 2015 at 1:28 am
Viewing 15 posts - 6,691 through 6,705 (of 49,571 total)