Viewing 15 posts - 991 through 1,005 (of 7,168 total)
Jeff Moden (6/11/2013)
For example, sp_MakeWebTask was very well documented and supported and it went away virtually overnight because Microsoft thought everyone would go ga-ga over SSRS :sick:
sp_MakeWebTask was likely dropped...
June 11, 2013 at 11:43 pm
Jeff Moden (6/11/2013)
opc.three (6/11/2013)
Thank you for bringing the conversation back to the original intent. Maybe you doing it will make it stick.
Great idea but YOU are not the one to...
June 11, 2013 at 10:38 pm
Tom_Sacramento (6/11/2013)
June 11, 2013 at 8:48 am
jasona.work (6/11/2013)
pchirags (6/8/2013)
SQLRNNR (6/7/2013)
The Dixie Flatline (6/7/2013)
L' Eomot Inversé (6/7/2013)
pchirags (6/7/2013)
bharatmata
hari
hair
Jai..
Alai
Dania
June 11, 2013 at 8:43 am
A table with no clustered index is a heap. A heap can have non-clustered indexes on it and it remains a heap. Just clarifying.
June 10, 2013 at 9:17 pm
calvo (6/10/2013)
This is on 2008 R2 SP2. I know there's a KB addressing a similar bug for 2008.
What's you're exact build #?
June 10, 2013 at 9:09 pm
Some benefits:
Auditing - if everyone logs in as themselves then you know who is doing what. If you want capture who changed a row you can use built in T-SQL...
June 10, 2013 at 9:05 pm
Since you're just starting out, SQL Server Books Online would be a great place for you to start. Post back with more specific questions after you have acquainted yourself with...
June 10, 2013 at 8:55 pm
poratips (6/9/2013)
We are looking any Data Security tool for out existing Data for Protection, we would like to do the Data Encryption and Data masking with some user activity reporting.
Anyone...
June 10, 2013 at 8:52 pm
Jeff Moden (6/10/2013)
opc.three (6/10/2013)
Eh, and really, who needs it? 😀Everyone who wants to avoid increasing the surface area by firing up SSIS. 😉
You mentioning Surface Area...laughable 😛
June 10, 2013 at 1:37 pm
Eh, and really, who needs it? 😀
June 10, 2013 at 12:36 pm
If anyone is interested in taking the detour named "xp_cmdshell" (I am not) please see these posts below where Jeff, and sometimes myself too, espouse the merits and demerits of...
June 10, 2013 at 9:40 am
Don't forget Visual Studio, the Cube design tool.
June 10, 2013 at 9:21 am
Jeff Moden (6/9/2013)
opc.three (6/9/2013)
Note that xp_dirtree is an undocumented stored procedure.
I absolutely agree. It would be much better to use something that's not only well documented, but tried and...
June 9, 2013 at 9:09 pm
The old school way uses polling. The .net framework will check a table to see if it has changed data since the last time it was polled. If it has...
June 9, 2013 at 5:46 pm
Viewing 15 posts - 991 through 1,005 (of 7,168 total)